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
how can u check no of records in a file?
what is join logical file?
what is logical file?
how can I automatically refresh a web page?
What is the Difference between command attention key and command function key ?
define what a data area is along with a brief example of what it may be used for?
what are the uses of factor1, factor2 and result field for the rpg operation code parm?
when do you use f-spec. Continuation line ?
is their a difference in cobol400 for the release 5.2 and 6.1 at the as400.
what is the version of os/400 that we have?
Hi,Please give me the the answer for these quesitons? 1.what is IFS and ICF and RAPE amd DISKET fils? explain with example please? 2.What is the difference between POST AND SPACE OPCODES? 3.Can anybody tell me default printerfile command and object type?
What is program status data structure(psds) in as400?
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)
how may a cgi control duplicate inputs?
what is the function of cpyf command?