Re: ALTER TABLE over multiple members

[Peter.Colpaert@xxxxxxxxxx]

Joel,

you could update the DDS source, and issue a CHGPF which mentions 
SRCFILE(LIBRARY/QDDSSRC)

This will automagically also change any depending logical files.

HTH,

Peter Colpaert
Application Developer
Massive - Kontich, Belgium
-----
Real developers never document.  If it was hard to write, it should be 
hard to understand.
-----




Joel Cochran <jrc@xxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
07/12/2004 15:35
Please respond to Midrange Systems Technical Discussion

 
        To:     midrange-l@xxxxxxxxxxxx
        cc: 
        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.