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

    Unanswered: Where to next value for a sequence?

    I am trying to find the next value for a sequence or identity in DB2 UDB v8.1. The column in the syssequences table do not have this value. Does DB2 keep this value in some other location?. Please let me know if you an answer. Thanks.

  2. #2
    Join Date
    Jan 2004
    Tallahassee, FL, USA
    org_seq is sequence name, to select nextvalue from sequence as below

    select nextval for org_seq from sysibm.sysdummy1

    --Lekharaju Ennam

Posting Permissions

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