Which is better LF or OPNQRYF ? When should we use LF and when should we use O

Categories >> Software >> MainFrame >> IBM AS400 >> IBM AS400 AllOther
Suggest New Category

Which is better LF or OPNQRYF ? When should we use LF and
when should we use OPNQRYF ?

Question Posted / manish dwivedi

5 Answers
16238 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Which is better LF or OPNQRYF ? When should we use LF and when should we use OPNQRYF ?..

Answer / vaiv20

It depends on the situation. Whenever any update, delete or
add is performed on file, access data paths to the logicals
are also updated hence if data is very huge in the file it
will take toll on system response time for doing the
update, delete or add operation.Hence take a call based on
this consideration. Also, if you want to create a view on a
physical file for not so frequent use its better to use
OPNQRYF.

Is This Answer Correct ?

14 Yes

0 No

Which is better LF or OPNQRYF ? When should we use LF and when should we use OPNQRYF ?..

Answer / 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

Which is better LF or OPNQRYF ? When should we use LF and when should we use OPNQRYF ?..

Answer / adarsh

It depends on the frequency of accessing the records from
physical file. If records are huge and frequency of
accessing them is high then go for LF , but if records are
huge or less but Frequency is minimal then go for QPNQRYF
as it does not create a permanent object.

Is This Answer Correct ?

3 Yes

1 No

Which is better LF or OPNQRYF ? When should we use LF and when should we use OPNQRYF ?..

Answer / arun

according to me
lf is used for upd(non joint lf),view,
in this path is permanent it occupies more spaces

openqryf is used for temp path ,
it can access 5 files

so opqryf is better

Is This Answer Correct ?

0 Yes

0 No

Which is better LF or OPNQRYF ? When should we use LF and when should we use OPNQRYF ?..

Answer / 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

More IBM AS400 AllOther Interview Questions

what opcode will be used to test the zone of a character field?

1 Answers IBM,

What is the purpose of USROPN keyword?

1 Answers CTS,

what is the purpose of ovrdta and ovrata keywords ?

1 Answers IBM,

Can fields be concatenated INa logical file level?