Thanks for responding to my post. You piqued my curiosity about partitioned tables so I looked it up. I had no idea that database allowed this. However my installation does not have DB2 Multisystem so the functionality does not appear to be available to me.
Anyhow, I learned something new today.
Paul
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of CRPence
Sent: Friday, August 03, 2012 3:04 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Change length of Source file
On 03 Aug 2012 11:05, Paul Therrien wrote:
Alter Table should fail on a multi-membered file. Not SQL-elian.
Only some specific actions like ADD CONSTRAINT will be prevented for an SQL ALTER TABLE on multiple member [i.e. non-SQL TABLE] database files. A simple ALTER COLUMN SET DATA TYPE CHAR(100), for example, will not prevented simply due to MAXMBRS(greater-than-1) nor actual member count greater than one. An attempt to add a constraint for instance, would be diagnosed as an error and prevented by SQLCODE -7008. A SQL TABLE with multiple partitions [implemented as members] are not restricted in the same manner. The attempt to ALTER TABLE of a Source Physical File, however, I confirmed [on v5r3] fails with -7001; as "not a database [data] file" versus being due to multiple members.
--
Regards, Chuck
--
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.
midrange.com
