By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,515 Members | 1,682 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,515 IT Pros & Developers. It's quick & easy.

V9 Column Rename

P: n/a
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

Jul 26 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Jul 26 '07 #2

P: n/a
On Jul 26, 12:22 pm, Serge Rielau <srie...@ca.ibm.comwrote:
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.
Jul 26 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.