PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

OPNQRYF Vs Logical File

View previous topic View next topic Go down

OPNQRYF Vs Logical File

Post  maran on Mon Jul 27, 2009 8:07 pm

1) What are the differences between them?

2) When do we go for LF and when do we go for OPNQRYF?
avatar
maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

Re: OPNQRYF Vs Logical File

Post  maran on Mon Jul 27, 2009 8:08 pm

Ques1: differences between LF & OPNQRYF.

LF -> Permanent object whereas OPNQRYF is temporary. LF have database records like date of creation no. of records etc., whereas OPNQRYF doesn't have.

Q2: When do we go for LF and when do we go for OPNQRYF
If the file is being used frequently and large amount of data (more than 1 lakh) then better to go for LF. If the file not used frequently and not having much more records then we go for OPNQRYF. Because to create the temp. access path OPNQRYF take much more time when compared to LF.
_________________
Regards,
Razuk.
avatar
maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum