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
- 20460 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
is it possible to create a physical file without dds?
how will you find a string using pdm?
What is %CHECK?
what is meant by object lock requests,held locks and locks waiting to be applied(wrkobjlck) why should we apply for locks.Please explain sir.
what are the different methods to access seu?
how can a message from a message file appear as a constant on the screen?
what is the version of os/400 that we have?
How do you check object lock
can you specify a display file to be used in the following modes input,output, or combined modes ?
what is the necessary keyword for non-join logical file?
what is the function of rlu ?
what is the maximum number of parameters allowed in rpg?
how to define to define a hidden filed in dspf ?
How to avoid using indicators in ile ?
what is rpg ?
