Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005
    Posts
    7

    Unanswered: Altering the Next Serial Value command

    I am trying to alter the next value of a serial column.

    I have the syntax as

    ALTER TABLE timecard MODIFY (tindex serial (1000))

    But this is not working.

    We are on informix 7 using dbaccess

    Anybody have any ideas?

    Thanks

  2. #2
    Join Date
    Feb 2005
    Posts
    43
    Do you want the next record to have a value of 1000 in the tindex column? Simply use 1000 during the next insert.

Posting Permissions

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