Which is better LF or OPNQRYF ? When should we use LF and
when should we use OPNQRYF ?
- 5 Answers
- 15167 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
how will you find a string using pdm?
how can you check for a records existence without causing and i/o (chain/read)?
what are the different opcodes available in rpg for database access ?
explain the purpose of keep and assume keywords?
What Is Default Data Type (if You Define Decimals '0') In Physical File?
what is the purpose of the indara keyword?
How to add 99 menu (page down) option in menu creation..
what are members?
define the purpose of the iter operation?
what are different types of substems?
the maximum number of subfiles that can be active for a single file is ____ .
what is the sequence when using cursor?
what key word is used when screen is re-display?
. How to know why the OPM job is in MSGWAIT state?..WHAT COULD BE THE REASON FOR it?
What Is The Error If We Don't Get Login Screen?
