What will be your approach in going either for OPNQRYF or
Logical files. Which one to go for?

Answer Posted / sulthan

OPNQRYF dynamically creates the records required according
to the parameterrs and this process could be slow. While
using logic files , we already have the a record fectching
path and it is faster. so if a program needs to be run
multiple times, use LF's and if once in a while, go for opnqryf.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to handle duplicate error handling in RPG?

1700


explain sflclr, sflend, sfldlt, and sflcsrrrn?

898


What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?

2528


what is an online rpg?

741


what is the use of sflnxtchg?

820






is this a rpg channel?

691


how can I tell when to replace the array?

712


how do I preserve and clean the array?

683


what is a rpg?

709


what happens when sflsiz = sflpag? What are the advantages and disadvantages?

720


When it is desirable to describe files Internally?

1202


do you use message subfiles? What are the necessary keywords required coding a message subfile?

698


How to declare the pull button in AS/400..

1889


When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?

519


What is ment by record level identifier?

668