-
V9 Column Rename
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
-
Re: V9 Column Rename
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
-
Re: V9 Column Rename
On Jul 26, 12:22 pm, Serge Rielau wrote:
> 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.
