Re: Members in SQL Table

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

I rarely use multi-member tables.  When I do, it is to save month-end 
date in an archive or to replace the S/36 workstation (?WS?) file 
processing that proliferates throughout this old software.

After Charles replied, I did a search (ask.com) and found a pretty 
recent (12 months ago; that still qualifies as "recent" even for us, 
right?) on partitioned tables by Mike Cain.  Didn't read the whole thing 
but skimmed it.  Pretty good documentation, but didn't read enough to 
see if it would help - if I had DB2 multisystem, which I don't.

Thanks.

	* Jerry C. Adams
*IBM System i Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
	615.995.7024
fax
	615.995.1201
email
	jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



rob@xxxxxxxxx wrote:
> Remember, you qualified that with "if I want/need 2-n members in a table". 
>  One alternative is to NOT use multiple members.
>
> Another option is to use the SPENDMONEY command and purchase DB2 multi 
> system so that you can use "partitioned" tables.  This, in effect, uses 
> multiple members.  Grinds me that IBM requires that product to use 
> partitioned tables though.
>
>
> Rob Berendt
>