User connected to database v9.5 and renames a column using Alter Table window. Below error occurs when executing the Alter command:
ALTER TABLE "DBO"."table"
RENAME COLUMN "col" TO "col1";
IBM.Data.DB2.DB2Exception: ERROR  [IBM][DB2/NT] SQL0104N An unexpected token "RENAME" was found following "TABLE "DBO"."table"". Expected tokens may include: "ALTER".
at IBM.Data.DB2.DB2Connection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at IBM.Data.DB2.DB2Command.a(Boolean A_0)
Toad 4.7 recreates the table with new column instead of issuing an Alter Table command.
Waiting for fix to be released in a future version of Toad for DB2.