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

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.