Which is better LF or OPNQRYF ? When should we use LF and
when should we use OPNQRYF ?

Answer Posted / adarsh

It depends on the frequency of accessing the records from
physical file. If records are huge and frequency of
accessing them is high then go for LF , but if records are
huge or less but Frequency is minimal then go for QPNQRYF
as it does not create a permanent object.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why we sometimes use same file name in file and tofile in ovrdbf and sometimes different?

673


how can you check for a records existence without causing and i/o (chain/read)?

1310


what is the function of cpyf command?

1030


how do you pass parameters in cl?

1068


different type of cursor?

647






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

624


what is sflpag and sflsiz ?

2326


what is rpg ?

964


what is a primary file?

1065


what is the command to know key fields of file?

631


what is meant by object lock requests,held locks and locks waiting to be applied(wrkobjlck) why should we apply for locks.Please explain sir.

5977


What is file access opcodes?

771


how to run other job when one job is active?

611


If I want to execute Sftp commands(LS & GET) stored in Physical file from CL program automatically...Can u Plz tell me how can I do this?...How the script will look?? THANX FOR NY HELP...

2195


how does the runqry show the output?

900