Which is better LF or OPNQRYF ? When should we use LF and
when should we use OPNQRYF ?
- 5 Answers
- 15277 Views
- HCL, I also Faced
- E-Mail Answers
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
what the purpose of ovrdta, ovrata keywords?
What is RETURN CURSER LOCATION in subfile?
what does vldcmdkey means?
name few ibm supplied libraries?
What is the maximum number of subfiles that can be specified in a display file?
which cl command is used to trap error messages during program execution?
what are the different types of variables available in cl?
Can we debug the MSGW JOBS?
Write a logic program for knowing the repeated number of a vowels in a given program?
when are the unique constraints executed?
how can a message from a message file appear as a constant on the screen?
What is program status data structure(psds) in as400?
How do you check object lock
what is a query can be run in which mode?
difference between view and index ?
