Sqlcode -199 when trying to export data

neelima
2010-09-17
2012-12-07
  • neelima
    neelima
    2010-09-17

    Hi ,
    I am trying to export data from DB2 using Jailer .I get following error(Working table scope is "session".If i use "global" then SQl code is -647. ).Any pointer would be really helpful :

    2010-09-17 09:23:59,639  INFO   - arguments: export "extractionmodel\test12.csv" com.ibm.db2.jcc.DB2Driver jdbc:db2://DALG:446/DALG tas008 "<password>" -e "extractionmodel\merch_lvl2.sql" -threads 1 -entities 50 -where "" -format SQL -schemamapping IZITSAD1= -source-schemamapping IZITSAD1= -t "datamodel\exclude-from-deletion.csv" -scope SESSION_LOCAL -datamodel datamodel -script-enhancer .
    2010-09-17 09:23:59,671  INFO   - Jailer 3.4.1
    2010-09-17 09:23:59,671  INFO   - exporting 'extractionmodel\test12.csv' to 'extractionmodel\merch_lvl2.sql'
    2010-09-17 09:23:59,827  INFO   - reading file 'C:\Data\jailer\jailer_ddl.sql'
    2010-09-17 09:24:00,202  INFO   - reading file 'C:\Data\jailer\jailer_ddl.sql'
    2010-09-17 09:24:01,733  INFO   - reading file 'C:\Data\jailer\jailer_ddl.sql'
    2010-09-17 09:24:02,171  ERROR  - DB2 SQL error: SQLCODE: -199, SQLSTATE: 42601, SQLERRMC: NOT;<END-OF-STATEMENT>
    com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -199, SQLSTATE: 42601, SQLERRMC: NOT;<END-OF-STATEMENT>
    at com.ibm.db2.jcc.a.cy.e(cy.java:1507)
    at com.ibm.db2.jcc.a.cy.b(cy.java:1085)
    at com.ibm.db2.jcc.b.bd.i(bd.java:223)
    at com.ibm.db2.jcc.b.bd.b(bd.java:49)
    at com.ibm.db2.jcc.b.r.b(r.java:42)
    at com.ibm.db2.jcc.b.bs.f(bs.java:138)
    at com.ibm.db2.jcc.a.cy.k(cy.java:1082)
    at com.ibm.db2.jcc.a.cy.a(cy.java:1778)
    at com.ibm.db2.jcc.a.cy.e(cy.java:696)
    at com.ibm.db2.jcc.a.cy.execute(cy.java:680)
    at net.sf.jailer.database.Session.execute(Session.java:573)
    at net.sf.jailer.util.SqlScriptExecutor.executeScript(SqlScriptExecutor.java:105)
    at net.sf.jailer.DDLCreator.createDDL(DDLCreator.java:158)
    at net.sf.jailer.DDLCreator.createDDL(DDLCreator.java:73)
    at net.sf.jailer.Jailer.export(Jailer.java:1062)
    at net.sf.jailer.Jailer.jailerMain(Jailer.java:989)
    at net.sf.jailer.ui.UIUtil$5.run(UIUtil.java:357)
    at java.lang.Thread.run(Unknown Source)
    Error: com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -199, SQLSTATE: 42601, SQLERRMC: NOT;<END-OF-STATEMENT>
    2010-09-17 09:24:02,202  ERROR  - working directory is C:\Data\jailer

     
  • Ralf Wisser
    Ralf Wisser
    2010-09-17

    Hi,

    seems that the generated DDL (file "jailer_ddl.sql") is incorrect. If you like, you can send the file to rwisser@users,sourceforge.net s.t. I can take a look into it.

    Ralf

     


Anonymous


Cancel   Add attachments