How to inner join more than 2 PFs in a CL program using
OPNQRYF command?
- 1 Answers
- 5745 Views
- I also Faced
- E-Mail Answers
Answer Posted / omer ozen
You don't. OPNQRYF is an abomination. Don't use it and use
a proper language to do your programming.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is file access opcodes?
What Is The Purpose Of The "n" In The Following Calculation Specification?
what is full form for dds?
Why we are not able to perform insert delete and update operation in Join logical file?
what key word is used when screen is re-display?
what are the various types of device files?
what does defn do?
is there any way to dynamically merge other html scripts into a given html?
how to define global parameter in ile ?
What is the default access path of a file?
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.
what are different record spacing keywords in rlu ?
can error messages as a result of a comp, range or values keyword be overridden?
how you will know whether you are in sfldrop or sflfold mode?
what is the purpose of putovr (put with explicit override) keyword?
