RE: SQL/DDL Column renames

Is the table in question is SQL or DDS defined?

If it is SQL defined, CREATE OR REPLACE TABLE should allow you to do what
you want

CREATE OR REPLACE TABLE myschema.mySQLtablename FOR SYSTEM NAME myddsfile (

FancySQLname FOR COLUMN COLUMN1 CHAR(40) CCSID 37 NOT NULL DEFAULT '' ,
FancySQLname2 FOR COLUMN COLUMN2 CHAR(40) CCSID 37 NOT NULL DEFAULT
''
...)

If the underlying file is still DDS defined, you have two options I can
think of:

1) build a VIEW over the DDS PF The resulting view will be updateable.
Point the SQL developers at the view rather than the underlying physical
table. No risk to existing programs attached to the current DDS format.


CREATE OR REPLACE VIEW myschema.mySQLviewname
(FancySQLName FOR COLUMN COLUMN1,FancySQLName2 FOR COLUMN COLUMN2)
AS SELECT COLUMN1,COLUMN2 FROM myschema.myddsfile;


2) rebuild the file using SQL.

IBM provides tools to generate the SQL from existing tables, even if DDS
created.
You need to worry about level checks and existing program usage if you go
this route