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
- 20276 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
What is diff between EVAL & MOVE?
What is data structure in as400? What is the use of data structure?
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 is the sequence when using cursor?
how can a message from a message file appear as a constant on the screen?
What are the different opcodes used for file operation on a subfile in a rpg pgm?
what is rpg ?
What are the mandatory keywords of sub file?
what is match field indicator?
If i change any file through application after entering data , how to check which file is updated through applications . For call stack we takes esc 3 then we chose 11..But What is answer of below qtn..?
what is the use of sflend keyword?
describe the difference between the dowxx and douxx operations?
What Is Ddm ?
define the purpose of the *cat function?
how can u check no of records in a file?
