V9 Column Rename

[mike_dba]

I am running V9 FP2 on DPF. I understand that V9 LUW now lets you
rename a column. I can't seem to get the sytax right. Can anyone
point me to what is wrong?

db2 "ALTER TABLE myschema.mytable RENAME COLUMN current_colname to
new_colname"

I'm getting :

DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0104N An unexpected token "rename" was found following
"ALTER TABLE myschema.mytable". Expected tokens may include:
"ALTER".
SQLSTATE=42601

[Serge Rielau]

mike_dba wrote:

I am running V9 FP2 on DPF. I understand that V9 LUW now lets you
rename a column. I can't seem to get the sytax right. Can anyone
point me to what is wrong?

DB2 9 for LUW does not directly support RENAME column.
You can rename a column indirectly by adding a new column with the
appropriate name and dropping the original after copying the data.

Support for RENAME column is known requirement.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[mike_dba]

On Jul 26, 12:22 pm, Serge Rielau <[e-mail]:

mike_dba wrote:

I am running V9 FP2 on DPF. I understand that V9 LUW now lets you
rename a column. I can't seem to get the sytax right. Can anyone
point me to what is wrong?

DB2 9 for LUW does not directly support RENAME column.
You can rename a column indirectly by adding a new column with the
appropriate name and dropping the original after copying the data.

Support for RENAME column is known requirement.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Thanks for the prompt reply. I mistakenly looked at the V9 z/OS
manual where it looks like it may be permitted.

Thanks again for your reponse.