RE: ALTER TABLE over multiple members

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

Joel,

Have you looked at CHGPF?  If you've already got DDS, it's simply a matter
of adding your new fields, save your source, and CHGPF will automagically
insert the new fields, leaving your data intact.  LFs with explicit field
definitions will need to be rebuilt, but this will not be necessary for
simple "key field" logicals.

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



-----Original Message-----
From: Joel Cochran [mailto:jrc@xxxxxxxxxx]
Sent: Tuesday, December 07, 2004 8:36 AM
To: midrange-l@xxxxxxxxxxxx
Subject: ALTER TABLE over multiple members


I need to add two new fields to a multi-member file.  Using DDS, I would
have to copy the file to another file, CRTPF, then copy the data back
member by member.  There is also a multi-member LF over this file. 
Rather than do that for 30+ members, I was wondering what would happen
if I used SQLs ALTER TABLE instead.  Will this work over multiple
members without the data-moving shenanigans?  If not, are there any
other recommendations for how to proceed with this project?

TIA,

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.