RE: Multi-format Logicals

Curt/Rob,

The limit is actually on the number of physical file members scoped by a logical
file's member, although I suspect it's also trapped if you have more than 32
PFILE statements in your DDS (I've never tried it).  The number is 32.  This is
true for multi-format logicals, join logicals, and logicals scoped over
multi-member physicals.  There used to be a manual, DB2 for AS/400 Database
Programming, but that manual on the softcopy now refers all questions to the
InfoCenter thing.  InfoCenter seems to have HTML and PDF versions of the manual
- maybe they didn't destroy this one so badly after all.

The only two things I know to do when the limit is too restrictive are:

1) Consolidate some of the physical members in some manner, temporarily or
permanently.

2) Resign yourself to having more than one logical and handling it
programmatically.  Do I hear Primary/Secondary files with matching record
processing? <grin>

Dave Shaw
Spartan International, Inc.
Spartanburg, SC

> -----Original Message-----
> From: Rob Berendt [mailto:rob@dekko.com]
> 
> More of a midrange-l question than an RPG400-L question, but 
> here goes.
> 
> Let me guess; you're using Harbinger/Premenos/ACS network 
> system or whatever name they are this week for your EDI right?
> 
> We've ran into that problem quite some time ago.  I think 
> that we had to redesign our file structure.  Like I said, 
> it's been awhile.
> 
> Curt.Penland@diverseylever.com on 03/06/2000 12:40:00 PM
> Please respond to RPG400-L@midrange.com@Internet
> To:   rpg400-l@midrange.com@Internet
> cc:    
> Fax to:       
> Subject:      Multi-format Logicals
> 
> Hi everyone.
> I think I have seen that there is a maximum number of 
> physicals that I can have
> in a multi-format logical.
> I need to create a multi-format logical over quite a few physicals.
> Can anyone tell me if there is a maximum number of physicals 
> in a multi-format
> logical?
> Can anyone offer any suggestions if I hit the maximum and 
> still need to add
> more?
> How about pointing me to some reading on the subject?
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---