Re: members

["Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>]

Hello John,

Multi-member files still have a use for historical data.  Physically 
partitioning such data allows me to sort 
the member (RGZPFM) and process sequentially with large blocking factors and I 
will get better performance 
then if I partitioned by key.  I can archive old data by saving and deleting 
the members and I don't have to 
worry about deleted record space.  Of course I could do this with multiple 
files but members seem a cleaner 
approach.

While it is true multi-member files can confuse less flexible platforms there 
are always mechanisms to 
work-around those limitations.

There may be no further enhancements to multi-member support (I doubt it) but 
the existing support is unlikely 
to be dropped.

Regards,
Simon Coulter.

//----------------------------------------------------------
// FlyByNight Software         AS/400 Technical Specialists
// Phone: +61 3 9419 0175      Mobile: +61 0411 091 400
// Fax:   +61 3 9419 0175      E-mail: shc@flybynight.com.au
// 
// Windoze should not be open at Warp speed.
//--- forwarded letter -------------------------------------------------------
> X-Mailer: Mozilla 4.04 [en] (Win95; I)
> Date: Sat, 26 Sep 98 21:54:29 -0700
> From: "John Earl" <johnearl@toolnet.com>
> To: MIDRANGE-L@midrange.com
> Reply-To: MIDRANGE-L@midrange.com
> Subject: Re: members

> boothm@ibm.net wrote:
> 
> > Someone said the other day that members are dead.  IBM has seen that no one 
>else is going down the members 
road, so they are pulling back and offering no further support beyond what we 
see right now.
> 
> Sounds like good news to me.  In a well architected database, I have 
>difficulty finding a use for members.  
In most (if not all) cases you could use a key field to get the deliniation 
that members
> provide.
> 
> Source files are a different issue, I'm not sure how IBM would ever get away 
>from using source members.  
It's too deeply embedded in the culture.
> 
> jte
> 
> >
> >
> > Does this fit with what others have heard?
> >
> > --
> > -----------------------------------------------------------
> > boothm@ibm.net
> > Booth Martin
> > -----------------------------------------------------------
> --
> John Earl   PowerTech Toolworks
> johnearl@toolnet.com  www.toolnet.com
> 253-858-7388   206-575-0711
> PowerLock Network Security for the AS/400
> --

+---
| 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
+---