how to retrieve particular field records from a physical
file,say i have a physical file called 'employee' in it i
have to retrieve the records of a field 'admin' present in
pf 'employee' using rpg,but i should not use logical file
or openquery file.
Answers were Sorted based on User's Feedback
Answer / gagandeep kaur
We can use embedded SQL in RPG to retreive records.It works
faster as comapred to other methods
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / satya
If this is a keyfld, u can directly call the record in 'factor1' setll filename then read.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is difference between bind by copy and bind by reference?
which program rpg or cl is efficent to update a transaction onto a database file and why ?
what is overlay? how can we pass parameters in cl or rpg programing? how can we get data area value in cl or rpg programming?
Need a sql query: retrieve all duplicate records in table?
To check the locks , we use cmd WRKOBJLCK , but how we confirm whether it's objeck lock / member lock. I confused with the Lock type and Status values...Can any body please tell me ...
What is SFLNXTCHG keyword why it has used and where? Briefly explain with Example.
Can an indexed file be accessed in arrival sequence in RPG?
1) How to retrieve RRN through RPG ? 2) How to pass parameter by value ? 3) How to trap the error through the RPG/400
10 Answers IBM, Tech Mahindra,
What is use of IMPORT and EXPORT in RPGLE ? What is activation Group ? What is Service Program ???? How to call another program in RPGLE ?
When PGMA calls PGMB for the first time PGMB executes the *INZSR. PGMB uses the RETRN operation to return to PGMA. When PGMA call PGMB the second time is the *INZSR executed?
Suppose we have 10 records with same name and we are reading using READE,after 4 record i have to use CHAIN what is the output
what is a rpg?