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 create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...

0 Answers  


Suppose we have 10 records with same name and we are reading using READE,after 4 record i have to use CHAIN what is the output

3 Answers  


i hav 2 logical files(L1,L2) both r derived from one physical file(P1). how can i use both the logical files in one RPG program? if yes what i have to d.

5 Answers   TCS,


how to display all the members records in a physical file without using ovrdbf?

9 Answers  


can we use cl programming to update or delete physical files

12 Answers  






What you have to do in the display file when you are using message subfile?

1 Answers  


what is the equivalent keyword for CHAIN opcode ??

7 Answers   TCS,


Have a join logical file with more than one members with different record formats. So how can we read the different members from this file and also how we can read the different record format from the join logical?

3 Answers  


in which journalling which attributes are necessary

2 Answers   CTS,


How can we receive values from a called procedure in RPG?

1 Answers  


In a particular program one file is used where override command is applied to a file, now this program calls another program where we want to use the same file but without override.How it can be done?

6 Answers   Hexaware,


I want to declare the number of elements of an array dynamically in RPGLE ? Is it possible? If yes, then how do I do it ?

2 Answers  


Categories