What will be your approach in going either for OPNQRYF or
Logical files. Which one to go for?
Answers were Sorted based on User's Feedback
Answer / 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 |
what is *place and *auto keyword in prtf ?plz explain
what is EXCEPT command in rpg and use
program to find the number of objects used in a given program through a display.
what is a rpg?
can i use unique key in LF
How to search particular records from the database file in rpg?
Please tell me how to read the records from a file with load an array of size with error conditions(The logic answer for this question is ARR is array of 99 elements Z-ADD 0 IDX *LOVAL SETLL FILE READ FILE 99 *IN99 DOWEQ *OFF IDX ANDLT 99 ADD 1 IDX MOVE FIELD ARR,IDX READ FILE 99 ENDDO).So,Please give me the complete of this code.
How to get only unique records from a file which contains duplicate data using CPYF command ? Example : FILEA has duplicate records and FILEB is a UNIQUE defined.... and I want to get the data from FILEA to FILEB by eliminating all the duplicate records...
Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?
how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE
What is ment by record level identifier?
1. I have2 records in a PF. READ PF DO DSPLY EMPNO RETRN DSPLY EMPNO ENDDO What was the output 2. SETON LR vs RETURN 3. Primary File 4. How to delete a deleted spaces 5. How to read a PF in reverse order in CL 6. I have a object in Lib A, B and C. But it shows in D Lib..Why? 7.