RE: Logical over multiple members -- MIDRANGE-L

Title: RE: Logical over multiple members

When you create the logical file the default parameter create exactly what you need:

CRTLF FILE(LIBRARY/LFNAME) SRCFILE(SRCLIB/QDDSSRC) MBR(*FILE) DTAMBRS(*ALL)

It creates one logical file member with the same name as the file, based on all the physical file members existing at the time of creation. As more members are added to the physical file they are not included as data members in the logical file member. You should be able to remove the logical file member and re-add it rather than deleting and recreating the entire logical file.

RMVM FILE(LIBRARY/LFNAME) MBR(LFNAME)

ADDLFM FILE(LIBRARY/LFNAME) MBR(LFNAME) DTAMBRS(*ALL)

-Jim

James Damato
Manager - Technical Administration
Dollar General Corporation
<mailto:jdamato@dollargeneral.com>

-----Original Message-----
From: Pillai, Sushama [mailto:spillai@automatedinstallment.com]
Sent: Friday, June 15, 2001 8:59 AM
To: MIDRANGE-L@midrange.com
Subject: RE: Logical over multiple members

Thanks a lot for all the inputs.

I want to be able to read all the data from all the members based on a key. What difference would it make whether I create one logical member or multiple? Does it make any difference to the way I read the logical ? And, if I use *ALL and create one logical, what should I do every time I add a new member to the physical, delete and re-create the logical?

Thanks again, guys.
Sushama

-----Original Message-----
From: Jim Damato [mailto:jdamato@dollargeneral.com]
Sent: Thursday, June 14, 2001 6:25 PM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: Logical over multiple members

Do you want your logical file to have a member for each physical file
member, or do you want a single logical file member to reference all the
members in the physical file? Look at the DTAMBRS parameter on CRTLF and
ADDLFM. The default is *ALL, which will create a member based on all
physical file members that exist at the time the logical file member is
created.

As you add physical file members you will have to either add new logical
file members to match them, or remove the main logical file member and
re-add it. It depends on how you're using the files.

-Jim

James Damato
Manager - Technical Administration
Dollar General Corporation
<mailto:jdamato@dollargeneral.com>

-----Original Message-----
From: Falconberry, Ron G. [mailto:PGRGF@mail.directins.com]
Sent: Thursday, June 14, 2001 5:43 PM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: Logical over multiple members

Sushama,

I assume that you are adding the new member to the physical file. Try using
the ADDLFM for each logical file and specify the new member name. This will
add the member to the logical file.

Ron

-----Original Message-----
From: Pillai, Sushama [mailto:spillai@automatedinstallment.com]
Sent: Thursday, June 14, 2001 5:06 PM
To: MIDRANGE-L@midrange.com
Subject: Logical over multiple members

Hi all,

I have a multiple member file and a I built a logical over it. But when I
add a new member, the logical does not get updated. Can someone tell me what
I should do other than recompiling the logical every time a member is added.
Any help is appreciated. Thank you in advance.

Sushama

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---