Skip to Content
0
Jan 26, 2014 at 06:13 AM

Rename table in DB2

586 Views

Hello Guys,

I am trying to rename a table in db2 which is not part of any schema. Unfortunately i am not able to it. I tried everything but it is not working. What i am doing wrong here ?

My DB2 version is 9.7

db2 => rename table QCM8/B28/XT6D64T to /B28/XT6D64T1

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 table" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "<values>".

SQLSTATE=42601

Regards,

Subhash