How to inner join more than 2 PFs in a CL program using
OPNQRYF command?



How to inner join more than 2 PFs in a CL program using OPNQRYF command?..

Answer / 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

More IBM AS400 AllOther Interview Questions

what are the different types of keys in AS400

2 Answers   HSBC,


any one have give AS400 study material? pls pass it to gopalsai789@gmail.com

0 Answers   IBM,


How many secondary files allowed in a program?

1 Answers  


in which specification the report layout can be defined?

1 Answers   IBM,


What is FCFO, FIFO, LIFO in Database environment ?

1 Answers  






Can an indexed file be accessed in arrival seQuence in RPG program ?

1 Answers  


How can I automate sftp commands(ls & get) in CL program.. If I want to write two scripts one for each command... can u plz tell where the script should be written? & what will be the content of each scripts?

1 Answers  


what is a physical file?

1 Answers   IBM,


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?Pls give the answer 1,,,,,,,to 12.........ie how it will happened like...for eg if a file is not closiing ,,,like this error is happened... if sufficient data is not in a pf to write in a display file. or sfldsp is not "on"......sessional or device error occured...like this give details all 1 to 12 errors (syam..)....give details PLsssssssssss?

1 Answers   CTS,


What are the different definition levels in Data Description Specifications?

1 Answers  


What is the exact difference between Service Program and Binding Directory?

1 Answers  


Define each of the following operation codes a, b, c, d, e

1 Answers  


Categories