Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Location
    Bali Indonesia
    Posts
    2

    Question Unanswered: Create Sequence Fails

    Hi All,

    I was using DB2 Win2k v.7.2

    I try to create sequence using:
    CREATE SEQUENCE SEQ_M_USERS

    and I've got following error messages:
    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 "CREATE ". Expected tokens may include: "JOIN <joined_table>". SQLSTATE=42601

    can someone help me, please

  2. #2
    Join Date
    Feb 2002
    Posts
    16
    Hi,
    in db2 we donn have create sequence,its Identity column type that works as sequence.

    M

  3. #3
    Join Date
    Mar 2002
    Location
    Bali Indonesia
    Posts
    2

    Question How to know current number of sequence?

    thank you for the reply,

    If we use indentity,
    how we can get the current number of sequence?

    for example, in oracle: SELECT SEQ_NAME.NEXTVAL FROM DUAL


Posting Permissions

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