Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    86

    Unanswered: how can I drop a sequence?

    hi,
    I created a sequence in db2v7.2, when I want to drop the sequence I get
    [/home/dba]db2 drop sequence bbb
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0104N An unexpected token "sequence" was found following "drop ".
    Expected tokens may include: "<server_or_server_mapping>". SQLSTATE=42601

    Please help

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    According to the SQl manual:

    Drop Sequence <sequence-name> RESTRICT

    HTH

    Andy

  3. #3
    Join Date
    Jul 2002
    Posts
    86
    Originally posted by ARWinner
    According to the SQl manual:

    Drop Sequence <sequence-name> RESTRICT

    HTH

    Andy
    Thank you so much for your help

Posting Permissions

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