RE: ALTER TABLE over multiple members

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Joel,

I'd say SQL Alter Table would probably work fine, but I'd definitely have to
test it out to know for sure.  SQL doesn't really work well with
multi-member files, but since this is a change to the file object, OS400
probably handles the underlying changes in exactly the same way.  Since
record format definition is part of the object attributes, changing the
record format should be global to all members of the object....

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Joel Cochran [mailto:jrc@xxxxxxxxxx]
Sent: Wednesday, December 08, 2004 6:05 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: ALTER TABLE over multiple members


Thanks to everyone who responded, CHGPF worked great... just out of
curiosity, if I hadn't had the source, would the ALTER TABLE have worked
in like fashion?  I may have to set up a test...

Joel
http://www.rpgnext.com

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