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



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

Answer / anuj tiwari

OPNQRYF is used to select certain records of the database file based on the QRYSLT (Query select ) condition.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More IBM AS400 AllOther Interview Questions

i have one physical file which is having two logical files. logical a have unique keyword and logical b doesnt have a unique keyword. can i give duplicate values while updating through physical file. if no why?

4 Answers   IBM,


how can a procedure will be added in to a srvpgm

4 Answers   TCS,


how to get no of records in file in rpg with out cl cmd

2 Answers   iGate,


What is the purpose of the following FORDHDR1 CF E WORKSTN $2SFN SFILE FMT2

1 Answers  


I have to execute 12000 CL Commands one by one.. So, I have created a file called COMMAND. This file has only 1 field called STRING. This file had 12000 records, and all these records are CL Commands (ex: CALL PGM(PGM1)), etc) I have written a CL which will read all the record and do sbmjob.. But it is not working... Plz help me to exexute all these 12000 commands..

2 Answers   ISE,


difference between view and index ?

0 Answers   IBM,


What is SFLPAG

1 Answers  


In there is 100 no. of recordsin PF, if i delete all the records. Then what is the Size of the PF?

9 Answers  


What is the difference between non-join logical files and join logical files?

0 Answers  


what is the use of dspatr(mdt) keyword?

1 Answers   IBM,


Hi friends.. i want to be a IBM MainFrame Professional.. can any body tell me what is requirement for that... i m just BA, MA, and have simple diploma in Computers. what is pre-requisite.

3 Answers  


how to get the cursor position?

0 Answers   IBM,


Categories