Hi All,
When I am trying to add cloumn in table with timestamp in DB2 I am getting error,
Could any one pls help me.
Here is the command which I am using...
db2 => alter table CEX_TEMP_SUBSCRIBER_MAX add X_PEND_EFF_END_DT timestamp 26
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 "26" was found following "EFF_END_DT timestamp".
Expected tokens may include: "END-OF-STATEMENT". SQLSTATE=42601
Regards,
ZameerAhamed