AW: DDS define files on SQL statements (multi member files)

["myibmi" <myibmi@xxxxxxxxxxx>]

It was a common technique at S/34-S/36 times. 
Switching to AS/400 I never used it again.

Karl

-----Ursprüngliche Nachricht-----
Von: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] Im Auftrag von
Frank Kolmann
Gesendet: Samstag, 3. September 2022 02:08
An: rpg400-l@xxxxxxxxxxxxxxxxxx
Betreff: Re: DDS define files on SQL statements (multi member files)

I dont know if SQL is better but I did work on a system with multi 
member files.
Multi member files are a total pain, IMO.

In the system I worked on each member represented a different company.
I was asked to fix a problem where the overrides were not properly 
implemented and one companies data was mixed up with others.

I decided to create multiple libraries, one for each company. Perhaps 
overkill, but how else could I ensure a fix I could guarantee to work?
I hardly needed no changes to the driving CLs, the overrides worked as 
usual even though each library had files with only one member.
There was a change needed to set the initial LL for when switching 
between companies.
Fixed the problem, back to single member files, such a relief.

Frank



On 03/09/2022 5:56 am, Peter Dow wrote:
> I'm in favor! (stuck at 7.3 and 7.4).
>
> On 9/2/2022 12:31 PM, Charles Wilt wrote:
> > Unfortunately, in order to create such a partitioned table, you need the
> > Db2 Multisystem product installed.
> > Prior to v7.5, this was a chargeable option that cost big bucks.
> >
> > With 7.5, IBM now includes it as a no-charge option.
> > I wonder, for those of us on 7.4 or 7.3, can we ask IBM nicely for a
> > license key.