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

check existence of one record without using chain or read?

1 Answers   IBM,


what is kids-rpg?

0 Answers   IBM,


HOW TO DELETE THE RECORD FROM MASTER FILE WHICH IS LINK BY ANOTHER TRASATION FILE WITH REFERTIAL INTYGRITY?

1 Answers   TCS,


What will be your approach in going either for OPNQRYF or Logical files. Which one to go for?

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  


Can any body give the code for this quesition? Using the following details write C-Spec code to set Name to"AMMU LABS SYSTEM" D NAME1 S 10 INZ('AMMU') D NAME2 S 10 INZ('LABS') D NAME3 S 10 INZ('SYSTEM') D NAME S 20

5 Answers  


Mr.Sidc sirfor my question{how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE} you have answered using MOVE opcode,can you illustrate me with a small example sir very kind of you.

1 Answers   CTS, IBM, iGate,


what is edit word and edit code

0 Answers   Cap Gemini,


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  


What hapens when we use CPYF command to copy a LF? On which PF will it be dependent???

7 Answers   HSBC, Systime,


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

2 Answers  


please help me answer to this question what is the difference between the binding and srvpgm in ilerpg?

4 Answers   HCL,


Categories