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 |
How to identify the object has compiled with the debug view as *source without using STRDBG?
what is batch debug in as400?
Hello, I want to extend a length of field in my Display file(Subfile). Please suggest the possible steps. Thanks
Some times While checking MSGW for object / member / record locks ,I have seen it's locked by itself ...? How it happen and what action we need to perform if job is updating / writing a record....?
What is the RPG cycle?
1.Are there any errors in the following statement?If so then list them.DTAARA is a data area having a field EMP # and EMPNO is a field in the file EMPPF.Which has one record. READ EMPPF IF %FOUND(EMPPF) IN DTAARA EVAL EMP#=EMPNO OUT DTAARA ENDIF
Need a sql query: retrieve all duplicate records in table?
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.
wat is the difference between array and multiple occurence data structure?
how do I declare a table or array in rpg iv?
How do I link an existing logical file to it's Physical File without recompiling?
Let?s consider a variable X of length 20. Move value ?ABC? to it.How to determine how many characters does X have?