Re: ALTER TABLE over multiple members

[vhamberg@xxxxxxxxxxx]

WEll, you don't need to do the copy/compile/copy back routine. Change the DDs 
and use CHGPF, naming the DDS source member, and the system will just do it for 
you. Prompt on the command and look espec. at the SRCFILE parameter.

HTH
Vern

-------------- Original message -------------- 

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