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?

Answers were Sorted based on User's Feedback



Have a join logical file with more than one members with different record formats. So how can we r..

Answer / keshar

Addition to above answer to read particular member in file
we can use OVRDBF command in CL. This will pointed out to
particular member and then we can do any operation.
Syntax:
OVRDBF FILE(file1) MBR(mbr1)

In RPG we can read particular member by keyword EXTMBR in F
specification.

The EXTMBR keyword specifies which member of the file is
opened. You can specify a member name, '*ALL', or '*FIRST'.
Note that '*ALL' and '*FIRST' must be specified in quotes,
since they are member "names", not RPG special words. The
value can be a literal or a variable. The default
is '*FIRST'.

The name must be in the correct case. For example, if you
specify EXTMBR(mbrname) and variable mbrname has the
value 'mbr1', the member will not be found. Instead, it
should have the value 'MBR1'

example:
Ffile1 IE K DISK EXTMBR('MBR1')

Is This Answer Correct ?    6 Yes 2 No

Have a join logical file with more than one members with different record formats. So how can we r..

Answer / pankaj

You can specify only one record format in a join logical
file.

Is This Answer Correct ?    2 Yes 1 No

Have a join logical file with more than one members with different record formats. So how can we r..

Answer / sarath

hi i am not able to find the extmbr in my f spec pls advice
if i am wrong.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More RPG400 Interview Questions

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

0 Answers   IBM,


Hi, can any one tell me :IN CASE OF SINGLE PAGE FILE HOW WILL I LOAD THE PREVIOUS PAGE WITHOUT THE USE OF SFLCLR INDICATOR ?

3 Answers   IBM,


in which journalling which attributes are necessary

2 Answers   CTS,


how many variables can we declare in cl pgm?

13 Answers  


how can we can we the data decimal error?how can we open such file in support

1 Answers  






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

4 Answers   Four soft,


I know whole thing ab't Arrays related to declaration..can anyone tell me what exactly use of array or anyone faced a situation where he found use of array must....

1 Answers  


What is the difference between inner join @ outer join

4 Answers  


Suppose we add one field in physical file and this physical file is used by several programs.how do we know which program is using that file? What are the impact analysis.

6 Answers  


can I touch the array during treatments?

0 Answers   IBM,


what is importance of 'MAPFLD' IN OPNQRYF FILE ?

2 Answers  


what do you mean by an input subfile, what are the keywords required?

0 Answers   IBM,


Categories