Interested to Buy Any Domain ? << Click Here >> for more details...
Can anybody please tell me what is difference between SQL
(STRSQL ) and WRKQRY .....?
- 3 Answers
- 20275 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jyoti
STRSQL is interactive user session where one can use the
SQL commands to query over the file/files. STRSQL even can
perform the file updates and deletions.
This is quick interactive session and does not lock the
file while file updations are performed.
WRKQRY is the mainly used when one needs to save the query
definition for reuse. The queries created using WRKQRY can
even be used in CL programs by RUNQRY (query name).
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / syam
In STRQRY you will get main 2 menus (Query for AS/400 and
Query Management). WRKQRY is one of the Option in STRQRY
(Query for AS/400). Only you want query some records from
database use WRKQRY.
| Is This Answer Correct ? | 8 Yes | 6 No |
how can u check no of records in a file?
Can anybody know difference between SNDUSRMSG AND SNDPGMMSG IN CL PROGRAMMING? IF DON'T KNOW MAIL ME @ gkarthik.as400@gmail.com
how many types of display are available on as/400 for user interaction?
how can a procedure will be added in to a srvpgm
If I want to execute Sftp commands(LS & GET) stored in Physical file from CL program automatically...Can u Plz tell me how can I do this?...How the script will look?? THANX FOR NY HELP...
How can you identify End of file in CLP program?
how do we know batch job aborted after we submitting it
what is the purpose of putovr (put with explicit override) keyword?
when are the unique constraints executed?
How many types of jobs?what is difference between interactive and batch and submited jobs?
OVRDBF FILE(xxx) TOFILE(libl/filename) share(*yes) In which scenario is share(*yes) used? could any one explain with an example?
How to write a password mask program in as400? like the password which i type should be displayed as '*****' r ###### which the user wishes to dispaly if u could help me with url r the solution in written code this will help me
RPG400 
