Results 1 to 2 of 2

Thread: DB2 Sequences.

  1. #1
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Unanswered: DB2 Sequences.

    Hello Everyone,

    We are using DB2 V8 Fixpack 3 on windows 2000 we have created a sequence and now want to change the value of the last assigned val in the sequence.

    I am trying the Alter Sequence Restart Option it works when I use a numeric value for eg db2 alter sequence s.s1 restart with 183;

    However when I try
    db2 alter sequence s.s1 restart with select max(temp) from temp;

    It fails any clues,ideas or suggestions to make the same work.

    Regards

    Nitin

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Nitin,
    The SQL Reference manual states that you can only use a numerical constant.

    There is no other option.

    Andy

Posting Permissions

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