PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

Join Logical File

View previous topic View next topic Go down

Join Logical File

Post  Kavithaa on Sat Oct 09, 2010 6:34 pm

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

View user profile

Back to top Go down

Re: Join Logical File

Post  abilash on Sat Oct 09, 2010 6:35 pm

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

abilash

Posts : 7
Join date : 2010-10-09

View user profile

Back to top Go down

Re: Join Logical File

Post  sivakumar on Sat Oct 09, 2010 6:59 pm

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')

sivakumar

Posts : 174
Join date : 2009-07-27
Age : 30
Location : Chennai

View user profile

Back to top Go down

Re: Join Logical File

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum