RE: CHGPF and ALTER TABLE

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