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
- 20301 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
how to run other job when one job is active?
what is *iso date format?
if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?
What is program status data structure(psds) in as400?
what is the purpose of ovrdta and ovrata keywords ?
define subsystem?
writing an sql statement from selecting records from two files using single statement and nested select statement.
what is message file?
define what a data queue is along with a brief example of what it may be used for?
what is the length of a variable in rpg?
in conjunction with what other keyword must ovrdta and ovrata be used?
which are the relational operators in rpg?
how many levels are there in a physical file?
can a indexed file be accessed in arrival sequence in rpg program?
how to validate input values in display file ?
