Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Location
    India
    Posts
    11

    Unanswered: using sequences crashes the db on Linux

    Hi all,
    I am facing a peculiar problem in my installation of v7.2 DB2 UDEE on Redhat Linux 7.2
    The documentaion does not have any ref to the "CREATE SEQUENCE " cmd but when i gave the cmd on it it allowed me to create a sequece, drop it and even list it from the syscat.sequences !! BUT the minute i try to use nextval or prevval the DB happily crashes !!! If someone has any ans to this plz help ... I prefer not to use identity columns unless relly no alternative is present.
    Thx
    Saka
    Cheers
    Saka
    :-)

  2. #2
    Join Date
    Apr 2002
    Posts
    18

  3. #3
    Join Date
    Dec 2005
    Posts
    1
    Quote Originally Posted by gregsimpson
    I can't get this web.
    use:
    nextval for sequencename
    next value for sequencename

Posting Permissions

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