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

Advertise your Business Here

Refer this Site

Login | Sign Up


	SiteMap shows list of All Categories in this site.

Categories >> Software >> MainFrame >> IBM AS400 >> IBM AS400 AllOther

RPG400 Interview Questions

COBOL400 Interview Questions

DB400 Interview Questions

COOLPLEX Interview Questions

IBM AS400 AllOther Interview Questions

Question

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

Question Submitted By :: Manish Dwivedi

I also faced this Question!!

Rank

Answer Posted By

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

Answer
# 1

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 ?

5 Yes

0 No

Vaiv20

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

Answer
# 2

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 ?

0 Yes

1 No

M Nihar

Question	Asked @	Answers
Other IBM AS400 AllOther Interview Questions


How we can delete all the Logical File of a Physical file in one instance ?	IBM	4
1) Can we declare a Display file in CL? 2) How many no. of files can be declared in a CL? 3) What is Non-Join Logical file and its importance?		2
What are Triggers?	Ordain-Solutions	8
is it possible to create a join logical file using two join logical files ? give exact reason for your answer	Ocwen	3
what is the purpose of DMPCLPGM IN CL?	IBM	2
Diff B/w ref and reffld?		1
WHAT IS ACTIVATION GROUP IN ILE?	Accenture	5
what is clile code get last digit in numarice value	CFC	1
What is SDA used for?		6
write a pgm to read p.f using cl pgm?	Ocwen	1
Hey, What is the difference between SCAN,CHECK,XLATE OPCODES? please give me the answeres with example in real time senario?		1
Hi friends.. i want to be a IBM MainFrame Professional.. can any body tell me what is requirement for that... i m just BA, MA, and have simple diploma in Computers. what is pre-requisite.		3
Why do you use Keep and Assume Keywords.	Four-soft	1
how can i get the cursor position in display screen to to display my window?		2
how can we view the entire objects and its types in a pgm?	Mind-Tree	6
How can we find from which source the program has been compiled for a given RPGLE program object?		3
Which is better LF or OPNQRYF ? When should we use LF and when should we use OPNQRYF ?	HCL	2
why we use binding directory and service pgm	TCS	2
Hello friends, i am new to AS/400. Can any one help me in AS/400 i meant say can you send me some FAQS and interview questions.	HanceInc	3
write the SQL statement to retrieve the 2nd Highest salary ammount(File Name="EMPLOY",Field Name="SALARY")		1

For more IBM AS400 AllOther Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com