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 |
what are the different types of arrays?
what is the maximum number of records you can specify in a display file?
What is the use of SDA ?
how to insert the data in pf by using cl program
I have a display file with mandatory fields. Is there anyway that i can highlight those fields to bring attention to the user? The same behavior that AS400 makes when we attempt to execute a command without completing all the required parameters. Note: I have used DSPATR(HI) or DPSATR(RI) and they have different behaviors. Thanks.
what is the purpose of the indara keyword?
What is %CHECK?
How do you read a subfile record which is in output mode?
What is a query can be displayed without saving it?
how can I control from my cgis the cache of a remote browser?
what is the maximum number of parameters allowed in clp?
Q.How can more than two program be executed in batch mode through SBMJOB in CL PGM but the condition is that program must be executed one by one?Please wtite the senario? 2. IS it possibe more then two programs can be executed in batch mode and HOw it will be executed in CL program ,please write the senario?