Join Logical File
3 posters
Page 1 of 1
Join Logical File
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?
Kavithaa- Posts : 5
Join date : 2010-10-09
Re: Join Logical File
You can specify only one record format in a join logical file.
abilash- Posts : 7
Join date : 2010-10-09
Re: Join Logical File
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')
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')
sivakumar- Posts : 174
Join date : 2009-07-27
Age : 37
Location : Chennai
Similar topics
» What are the reasons a logical file may be "dropped" during the File definition load process?
» Do the multi format logical file need to have same key field attributes for each record format? what is the significance of K *None in such Logical files?
» Physical File & Logical File
» Creating a Logical File or Index
» Multiple Format Logical file and Multiple logical files
» Do the multi format logical file need to have same key field attributes for each record format? what is the significance of K *None in such Logical files?
» Physical File & Logical File
» Creating a Logical File or Index
» Multiple Format Logical file and Multiple logical files
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum