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
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 |
Answer / pankaj
You can specify only one record format in a join logical
file.
| Is This Answer Correct ? | 2 Yes | 1 No |
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 |
How to update selected fields from pf without using update opcode. How to read all member in Rpg-3,without using any cl command?
How to add 2 new fields in a file? How many ways are there in as400?
what is estimation? and what is the level identifier parameter in PF?
1.Write code to read the records from a file and load an array of size 99? Make sure that you take care of all the error conditions?
In how many ways a session/device error occurs,,, and what is the remedy for it?
how do u track msg in cl pgm???
Hi,This is raju.Can any body give me the real experience answer for this question? 1.What is the significance of *MAP and *DROP in the CPY command?
How do I read records from Subfile? what is the purpose of READC explain with example?
parameters cannot be passed in which one???
How I can reread the physical file in CL program once the end of file reached in same CL program.
WHAT IS MONMSG IDENTIFIER FOR STRTCPFTP command IN cl (as/400)?
How can we override a file during runtime in rpg?