RE: Members in SQL Table -- MIDRANGE-L

Yes and no :)

v5r3(?) offers support of partitioned tables which are implemented as, tada...multi-member physical
file objects.

However, to create a partitioned table you have to have DB2 Multisystem installed.

Search for "partitioned table" in the infocenter or the archives.

HTH,
Charles

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jerry Adams
Sent: Thursday, December 06, 2007 7:43 AM
To: Midrange-L
Subject: Members in SQL Table

I realize that SQL has no concept of physical file members, but I
figured that I could add members (ADDPFM) to a table that was
created by
DDL. When I tried to do that, I got an error that the table
already had
the maximum number of members allowed by the MAXMBRS parameter.

Not being daunted by this minor setback, I went to the CHGPF
command to
change the MAXMBRS. But it failed with error message CPD3213:

Message . . . . : Maximum-member value not valid for file
PRICEN.
Cause . . . . . : File PRICEN in library PROJ171 is either a
Structured
Query Language (SQL) table, view or index, or a non-SQL
file that is
an SQL
materialized query table or is in SQL data base
PROJ171.
SQL tables, views, and indexes, and non-SQL files that are an
SQL
materialized query table or are in an SQL data base must have only
one
member; however, the value that you specified on the maximum number
of
members (MAXMBRS) parameter is either a number greater than one or
*NOMAX.

So it appears that, if I want/need 2-n members in a table, I
still have
to use DDS. Right? Or is there a work around?

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>

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

This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.