Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    hyderabad
    Posts
    10

    Unanswered: adding default value to existing table

    hi

    i am trying to set a default value for a column how to do this

    ALTER TABLE FS_AC_ACCTMASTER ALTER COLUMN ACCTDATE set DEFAULT CURRENT TIMESTAMP;


    what's wrong with this statement

    ramakrishna

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Doesn't look like what you're trying to do is supported by the ALTER TABLE command, per the SQL Ref.

    See the allowable syntax for "column-alteration"...
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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