OPNQRYF Vs Logical File
Page 1 of 1
OPNQRYF Vs Logical File
1) What are the differences between them?
2) When do we go for LF and when do we go for OPNQRYF?
2) When do we go for LF and when do we go for OPNQRYF?
Re: OPNQRYF Vs Logical File
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.
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.
Similar topics
» What are the reasons a logical file may be "dropped" during the File definition load process?
» Do the multi format logical file need to have same key field attributes for each record format? what is the significance of K *None in such Logical files?
» Physical File & Logical File
» Phyical File & Logical File.
» Multiple Format Logical file and Multiple logical files
» Do the multi format logical file need to have same key field attributes for each record format? what is the significance of K *None in such Logical files?
» Physical File & Logical File
» Phyical File & Logical File.
» Multiple Format Logical file and Multiple logical files
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum