adspace


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

Answer Posted / reecha

If the no. of records to be filtered is less then OPNQRYF
is better option then LF becoz it create temporaray ODP
only & overhead on system is less.


if teh records to be filtered out are more ten LF sud be
created

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1803


how can you specify no duplicate key?

1237


The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...

2436


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...

2851


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

1333