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 the forum, it's quick and easy

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

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Join Logical File

3 posters

Go down

Join Logical File Empty Join Logical File

Post  Kavithaa 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

Back to top Go down

Join Logical File Empty Re: Join Logical File

Post  abilash 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

Back to top Go down

Join Logical File Empty Re: Join Logical File

Post  sivakumar 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 : 37
Location : Chennai

Back to top Go down

Join Logical File Empty Re: Join Logical File

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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