Re: SQL/DDL Column renames

You could also create modified DDS source to specify ALIAS names for the fields, and then use CHGPF to alter the table.
You can also use the SQL ALTER TABLE statement directly against a physical file that was originally created by using DDS and CRTPF.

On Friday, November 30, 2018, 3:09:38 PM EST, Jack Callahan <jjcllhn@xxxxxxxxx> wrote:

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