× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Yes, it's quite easy but it involves the SPENDMONEY command.
In SQL talk a member is a partition. Hence this is why you can find a list of all "members" in SYSPARTITIONSTAT.
One difference is that SQL rather picks the partition by some criteria. For example you can partition your tables by REGION. However, unlike how people often set up their "members" on a DDS table, you would use a REGION column also. Back when disk was at a premium it would gag someone to add a column called REGION when you already knew that by the partition (aka member) name.
Search for the partition clause in the CREATE TABLE statement in the Knowledge center.

But, here's where the SPENDMONEY command comes into play. To use partitioned tables you must purchase and install DB2 Multisystem (make sure you get the right thing, many people confuse it for another option). If the cost is roughly the same as for a new P9 loaded with SSD's then you've got the right product. Even if you plan on only using partitioned tables on a single system you still need DB2 Multisystem. IBM will not unbundle partitioned tables out of DB2 Multisystem. I tried with an RFE but it got shot down.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of a4g atl
Sent: Thursday, January 17, 2019 8:14 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Sometime you need multiple members in a table.

I have a situation where I have a table defined. In the past I used PFs.
The table has a long and short name. This prevents me from using CPYF or CRTDUPOBJ. I have used RUNSQL to do a Create Table ... as (select..) with no data. This creates a table not a PF, okay.

I need a PF with Multiple members that is identical to the table. I use the member to store copies of file we send to external systems as an archive.
The member functionality has been great for this and I do not want to have hundreds of files in the library.

I do not have DDS but I could create DDS but would prefer not to. That makes it 2 different objects to maintain.

Is there a way to create a PF from a table?

TIA

Darryl Freinkel
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.