Which is better LF or OPNQRYF ? When should we use LF and
when should we use OPNQRYF ?
- 5 Answers
- 15249 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / m nihar
OPNQRYF is better then LF. Coz , OPNQRYF creates temporary
access path but LF creates permanent objects.
When we use all fields of your file then we use OPNQRYF for
temporaryly use. But when we use some choosen fields from
file then we use LF.
| Is This Answer Correct ? | 2 Yes | 10 No |
Post New Answer View All Answers
Write a CL program which will run a batch job at 1 am every night
can a join logical file be updated?
In RPG How to read a records from a file without using read opcodes?
i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.
when would you prefer logical file than opnqryf?
Write a logic program for knowing the repeated number of a vowels in a given program?
explain the use of dftwrt display keyword?
What are the different opcodes used for file operation on a subfile in a rpg pgm?
when are the referential constraints executed?
maximum number of subfiles that can defined in a rpg program for one display file is?
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?
which type of object is used in db2/400?
what does dfu program you to do on a record?
what is the difference between normal upddta to pf and updating using dfu program?
how to develop some simple graphs (bar charts) using just html?
