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 |
Difference Between Call & Sbmjob?
Q.Hi All friends, I have one Question, I have three fields in display file SUP LOT, ISSUED to Prod and Line Grp. Field SUP LOT is mentioned in one field reference file WRSLT and key field as a key field LP.Fields ISSUED to PROD,Line GRP are mentioned in the another Field reference file WMDTF. So I want to read SUP LOT on the basis of key field LP from the first file WFSLTand then i want ot read another two fields ISSUED to DATE and LINE GRP from second file on the basis of SUP LOT, which i got from first file.Now i want to display these fields in the display file DSPWMMS. but Condition is that 'Supplier Lot,ISSUED to Prod and Line Grp will not be shown if their respective fields are blanks/Zero. Please Let me Know coding part of this senerio and what would be coding for display file to now shown fields if fields are blanks/zero. My mob. no. is 9836300345. Please reply me asap.
what are dds required for subfile?
can we creat a member logical file
Explain this error: "all record formats for externally-described file abcd ignored or dropped due to error; file ignored."?
Define a Job Queue?
what is the difference between udate and the system date?
how to declare a constant variable in the freeformat?
what does defn do?
what is procedure prototype and procedure interface.
what is message subfile?
Describe the function of SETLL operation in RPG language?