Thanks gagan for your answer,i'm new to as400,i don't know
embedded sql in rpg.can you send me the coding for the below
mentioned question in embedded sql rpg.
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.
Answer Posted / ravi
Give DOW SQLCOD =0. There are several other errors with SQLCOD <> 0
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how do you use commitment control in rpg?
what is the difference between do while and do until?
How can we override a file during runtime in rpg?
1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
What is the difference between copybooks and subprocedures in as400?
How Chain operation copies the record's data to the input buffer for the program?
what is program status data structure?
What is the purpose of record level identifier?
what is file information data structure?
1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.
how can you display specific subfile page on the screen in unequal subfile?
How to select highest score of each subject or how to select highest income of every month?
what is a rpg?