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 |
can a single screen format occupy a screen area above and below a subfile format ?
In Which Specs Arrays, Tables & Constants Are Defined?
How can we find from which source the program has been compiled for a given RPGLE program object?
not all command typed on command line are cl command? true r false
what are all the contents of subfile?
what are the types of errors available in rpg IV or 400.Like decimal data error,sessional error or device error etc...means important error occurings,ie to find out suddenly???pls give answ if u know?
what is qcmdexc?
How do you check object lock
what are the limitations of cl (compare to rpg) ?
define the purpose of the %sst function?
Can we use OVRDBF command without using of OPNQRYF ? Or can we use OPNQRYF command without using of OVRDBF command ?
what is rpg ?