RENAME COLUMN col_old_name TO col_new_name;
However, when I try to run this DDL, I get this message "Lookup Error - DB2 Database Error: ERROR  [IBM][DB2/NT64] SQL0104N An unexpected token “RENAME” was found following “tablename”. Expected tokens may include: “ALTER”.
How do I fix this?
I understand that ALTER COLUMN is not available in DB2 LUW V9.5. How do I force Toad to treat the DB as 9.5 instead of a 9.7 DB?
I’m trying to rename a column in a version 9.5.7 DB2 LUW database. I’m using ‘ALTER TABLE’ and then highlighting the column to change it to a new name. The DDL created by Toad looks like this:
ALTER TABLE tablename