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
- 20277 Views
- I also Faced
- E-Mail Answers
Answer Posted / sathya
Inserting a record into physical file is not possible using
wrkqry.
Unique and distinct records cannot be derived from wrkqry.
Where strsql can gives access to do both.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
how can we run a batch job?
at what level s,o are defined and what they will do?
how do u compile rpgle program?
when would you prefer logical file than opnqryf?
if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?
which cl command can be used at program execution to redirect the file named in an rpg program?
Why we are not able to perform insert delete and update operation in Join logical file?
what is sflinz and sflrna?
what is the function of cpysplf command?
What is RETURN CURSER LOCATION in subfile?
i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.
can we define multi-dimensional arrays in rpg ?
explain the use of dftwrt display keyword?
which single rpg opcode performs both setll and reade?
what the purpose of ovrdta, ovrata keywords?
