Can anybody please tell me what is difference between SQL
(STRSQL ) and WRKQRY .....?
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 |
In Which Specs Arrays, Tables & Constants Are Defined?
how many types of display are available on as/400 for user interaction?
what is match field indicator?
What is diff between EVAL & MOVE?
how do you detect unused spool storage?
how would you design the process for a nightly, high volume check producing process that needs to select only records that are flagged to be processed?
How do I release jobs in queue and change a job destination to a different printer. I know wrkjobq but I have not worked with As/400 for a while,so_can someone help me?
which are the figurative constants used in rpg?
Difference Between Skip Before & Space Before?
under given circumstances, my cgi should link to another site. How to implement this?
Define each of the following operation codes a, b, c, d, e
how many printer files can be defined in f specs ?