Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



how to retrieve particular field records from a physical file,say i have a physical file called &#..

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

how to retrieve particular field records from a physical file,say i have a physical file called &#..

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 retrieve particular field records from a physical file,say i have a physical file called &#..

Answer / sbakshi4

The Opcode Except can be used to partially write the file .It is mainly used to printer files .

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More RPG400 Interview Questions

How to identify the object has compiled with the debug view as *source without using STRDBG?

6 Answers  


what is batch debug in as400?

3 Answers  


Hello, I want to extend a length of field in my Display file(Subfile). Please suggest the possible steps. Thanks

3 Answers  


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....?

6 Answers   HSBC,


What is the RPG cycle?

3 Answers   CSC,


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

5 Answers  


Need a sql query: retrieve all duplicate records in table?

1 Answers  


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   iGate, Wipro,


wat is the difference between array and multiple occurence data structure?

4 Answers   Four soft,


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

0 Answers   IBM,


How do I link an existing logical file to it's Physical File without recompiling?

2 Answers  


Let?s consider a variable X of length 20. Move value ?ABC? to it.How to determine how many characters does X have?

1 Answers  


Categories