Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2008
    Posts
    5

    Unanswered: Creat Table failure

    Hi,

    I'm new at DB2.

    On executing a create table script, this error shows:
    "
    com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=CREATE TABLE T_CHAMBER_TYPE_IAG
    (ID BIG;BEGIN-OF-STATEMENT;<space>, DRIVER=3.50.152
    at com.ibm.db2.jcc.b.wc.a(wc.java:579).... etc.
    "

    I'm using SQL Developer 2.3.0.

    Any help is appreciated.
    Mayam.

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    syntax error...
    plz post the ddl you are using
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    And don't forget to mention which DB2 version you are using on which platform...
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Sep 2008
    Posts
    5
    Found the answer.

  5. #5
    Join Date
    Sep 2008
    Posts
    5
    ...forgot to enable semicolon.

Posting Permissions

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