Re: SQL create a new file from another PF ith a new field at end of row?

On 29-Mar-2012 08:42 , Stone, Joel wrote:

Is it possible to create a file by inheriting all the fields and
attributes from an existing PF, and adding a new field to the end of
the row?

(Without defining each existing field in the CREATE TABLE
statement?)

Many ways; depending on many possible requirements or restrictions, according to the specifics of a scenario. Expectations for effect will vary widely so no /one way/ will always suffice. Each means will have its own caveats, limitations, and nuances that [attempt to] resolve or suffer from the complexities associated in so doing, here are a few:

create table FileName2 like FileName -- parentheses change effect
alter table FileName2 add column ...

crtdupobj FileName LibrName *FILE LibrName2 FileName2 ...
alter table FileName2 add column ... /* or chgpf srcfile() */

retrieve existing DDL, insert new column source, execute immed

savobj and rstobj with rename(s) before and\or after save

update the production DDL, create and promote new TABLE, then
effect alter or other means to upgrade existing TABLE

Regards, Chuck