RE: CHGPF and ALTER TABLE

[rob@xxxxxxxxx]

See, if this was on midrange-l, where it belongs, you would have probably 
received the answer by now that you can easily retrieve the SQL used to 
create the file

CREATE TABLE ROB/JERRYA 
(MYFIELD CHAR (5 ) NOT NULL WITH DEFAULT,
COLUMNA CHAR (2 ) NOT NULL WITH DEFAULT) 

ALTER TABLE ROB/JERRYA 
ADD COLUMN BUBBA DEC (5 , 0) NOT NULL WITH DEFAULT

Then you can use iNav's Generate SQL Scripts to retrieve:
--  Generate SQL 
--  Version:                    V6R1M0 080215 
--  Generated on:               07/28/09 09:17:35 
--  Relational Database:        GDIHQ 
--  Standards Option:           DB2 i5/OS 
CREATE TABLE ROB.JERRYA ( 
        MYFIELD CHAR(5) CCSID 37 NOT NULL DEFAULT '' , 
        COLUMNA CHAR(2) CCSID 37 NOT NULL DEFAULT '' , 
        BUBBA DECIMAL(5, 0) NOT NULL DEFAULT 0 ) 
        ;

There's gotta be an api out there to do the same.

As part of your process you could easily incorporate this.



Rob Berendt