Can anybody please tell me what is difference between SQL
(STRSQL ) and WRKQRY .....?
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
how can a cgi check whether an ifs object is available?
what are different record spacing keywords in rlu ?
writing an sql statement from selecting records from two files using single statement and nested select statement.
what is a keyed physical file?
what opcode will be used to test the zone of a character field?
how will you search an array?
what would be the effect on the field where reverse image, underline and highlight display attributes were active?
when do you use f-spec. Continuation line ?
what is the use of sflend keyword?
Write a CL program which will run a batch job at 1 am every night
what are the basic features of seu?
Difference Between Source Physical File & Physical File?
during input operation which indicator position is seton if there is a record lock?
What is program status data structure(psds) in as400?
how many printer files can be defined in f specs ?