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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?

2373


What is the difference between iter and do?

676


What is file identifier where we can use?

652


how can I tell when to replace the array?

702


what is a rpg?

701






We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?

769


thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400

1895


Interviewer asked me write down DDS for load all subfile .can anybody write dds

1019


can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com

1968


How to declare the pull button in AS/400..

1882


how do I declare a table or array in rpg iv?

737


what is the use of sflnxtchg?

803


Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?

1455


what is data area and how it is used in rpg program ?

756


How to call one program from another program in RPG? please help me with the code

1260