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.
- 3 Answers
- 8303 Views
- iGate, Wipro, I also Faced
- E-Mail Answers
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 |
Errors in Sql query will be in which state?
how can we can we the data decimal error?how can we open such file in support
Can we have a Physical file without any member ? Please let me know
How to find d key field of a pf that doesn’t have source physical file?
can anybody help me to solve this problem. the program that i m checking display error message saying "Record format for file AJDSPFFD does not match model file and decimal error. how to solve this problem. The AJDSPFFD is snapshot the AJTLOG that is the audit trail list.
check existence of one record without using chain or read?
One of the job in subsystem is in Running status,expected time to complete this job is 2 minutes. But from last 5 -10 minutes this job is still in running status....What are the possible reasons...and What are the actions i need to perform to check this...?
steps involved in debugging and types of debugging modes?
I have one cl program which calls two rpg programs named a & b. I am loading a run time array in Pgm A and the control comes back to cl pgm. i call pgmb and I want to read the runtime array in pgmb which was loaded in pgma. How it can be acheived. I should not use any intermediate file or dataarea to store the loaded values.
If record-format name in an externally-described file has already been defined as a file-name.how to solve this?
3 members in a databasefile .how to read records from all the members?????????
How can we know running job is batch or interactive?
RPG400 
