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
What is dynslt?
what is a program described file in rpg?
how many printer files maximum can be used in single rpg program?
what is the version of os/400 that we have?
Apart from opening of a file do we have any other use of USROPN?
how to pick up the changed records every time in a subfile after the first change made ?
when are the referential constraints executed?
hi guys i am new for sqlrpgle, please suggest me good websites and theory and coding. plz plz its very urgent.
Write a CL program which will run a batch job at 1 am every night
what is a query can be run in which mode?
How we will get issues on AS/400 technology ? I mean which issue/Defect Tracking tool is using in all companies when any issue comes? Can anybody explain about the work flow of AS/400 project ? plzzz
what is the use of data structures?
how can I predict the performance of my cgis?
what does defn do?
what is the maximum number of subfiles that can specified in a display file ?