Suppose you have 3 members in a database file. How to read
records from all the members
Without using CL (OVRDBF) i.e. it should be handled
exclusively in an RPG program?

Answer Posted / sumit gupta

if you want to read a particular member/or all member
records in RPG program without OVRDBF in CL program. Then,
you can use EXTMBR keyword.

Declare a file in f specs and in keyword option write
1) EXTMBR(*ALL)
or
2) EXTMBR(MEMBER NAME)

Member Name must be in CAPS as if you dont put it in CAPS
then severity 30 error comes while compilation.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference Between Call & Sbmjob?

1027


what are the different types of variables available in cl?

1384


what is logical file?

808


what is the maximum number of subroutines allowed in rpg?

1413


how to develop some simple graphs (bar charts) using just html?

863


what is the use of unique keyword and what level it is defined?

1265


what are the different methods to access seu?

837


define what a data queue is along with a brief example of what it may be used for?

1437


Pose, there are 100 records in the file.i need to retrieve all the records matching/equal to the particular name field. How can we do the above using search criteria other than using the if cond?

823


The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...

2125


if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?

1358


what is the purpose of ovrdta (override data) keyword?

1437


how does union file maintains record formats?

864


What is binder language ?

1673


WHICH REPLY CODE IS USED BT sftp ? ... (e.g.226 is used by FTP IF FILE IS TRANSFERED)

1926