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 |
Anybody can explain the difference between SFLCLR & SFLINZ?
Suppose you have 3 members in a database file. How to read records from all the members without using CL (OVRDBF) i.e. Entire process should be handled exclusively in a RPG program?
what is decimal data error? when it will come and how to achieve(rectify) this error please give me solution as well as code
How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
I have a RPG program of 100 Lines and first line is to SETON indicator LR. Will the program execute rest of the 99 Lines?
Mr.Yallamanda Reddy P thanks for your answer sir,can we use test(D) opcode in RPG/400,if yes please help me by eloborating on that answer by writing a sample code for that sir
There is a excel sheet having details of Old account number and new account number. I need to update these details in my AS400 files. i.e. all the records having old account number should be replaced with new account number. There can be 100 or 200 or 300 PFs...no fix files known. how can we do this?Solution should be performance oriented
please guys help me,I need to write a program that shows more than one way to display a subfile. Both views are of the same file but sorted differently and show different fields of the same file when the user presses a function key. send me code
What is the difference between iter and do?
Anyone help me for the below question:- If problem/error occur in *PSSR subroutine,how should I handel it in RPG program.
what is commitment control?explain about it?
without logical file we cannot access the data in physical file.but we specify physical file in the program(ie:- Ffile IF E k disk).how can it be accessed?