ALTER TABLE over multiple members

[Joel Cochran <jrc@xxxxxxxxxx>]

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