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

Hi,Can any body give the code for the below mentioned quetion.?Im trying to get coding in with easily inderstanding.Plese give me the coding for this? 1.How would you achieve this requirement with out using RPG/RPGLE pgm,but by using only CL?Read a database file and display file contents on the screen when enter key pressed the next record should be displayed on screen.When the last record is reached or when F3 key is pressed the program should exit if the file is empty,a message should be displayed indicate that there are no records to display. Database file Name=EMPDBF Fields in EMPDBF to be displayed on screen Employee Number- EMPNUM(5,0) Employee Name- EMPNAM(30,A) Employee Address-EMP ADDR(50 A)

0 Answers   TCS,


What is data structure in as400? What is the use of data structure?

0 Answers  


how to change job priority when it is running in sub system ?

11 Answers   IBM,


How to convert a spool file to PDF file in AS400?

0 Answers  


what is clile code get last digit in numarice value

2 Answers   CFC,






what does the opcode free do?

1 Answers   IBM,


Pgm A is invoked through HTTP. It is in Activtion group QILE. Pgm A calls Pgm B and Pgm C. Pgm B is in activation group TEMPACTGRP. Pgm A ends in error. Pgm A is called again. But it gives an error that TEMPACTGRP still exists and files are present in QTEMP. What is the cause and how will u fix?

1 Answers  


1.what is mean by compilation and runtime error? 2.How to define ALFA numeric value in pf? 3.what command is used to define a data in cl pgm? 4.What type of command is used in page at a time subfile and load all subfile?

2 Answers  


Why do you use Keep and Assume Keywords.

2 Answers   Four soft,


how can I predict the performance of my cgis?

0 Answers   IBM,


What is the purpose of OPNQRYF (Open Query File)?

1 Answers  


what is lokup opcode?

1 Answers   IBM,


Categories