Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008

    Red face Unanswered: DB2 TIMESTAMP error

    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


  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    Let me repeat the message in other words: What's the 26 doing there?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts