All pastes #399619 Raw Edit

Plouj

public text v1 · immutable
·published 2007-03-18 03:09 UTC
rendered paste body
SQLException information:
Error msg: [IBM][CLI Driver][DB2/LINUX] SQL0104N  An unexpected token "C" was found following "ECT cidFROM Customer".  Expected tokens may include:  "<space>".  SQLSTATE=42601

SQLState: 42601
Error code:  -104
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0104N  An unexpected token "C" was found following "ECT cidFROM Customer".  Expected tokens may include:  "<space>".  SQLSTATE=42601

	at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
	at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
	at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source)
	at COM.ibm.db2.jdbc.app.DB2Statement.execute2(Unknown Source)
	at COM.ibm.db2.jdbc.app.DB2Statement.execute(Unknown Source)
	at A21.main(A21.java:36)

relevant code:

                        String myQuery = "" +
                                "SELECT cid " +
                                "FROM Customer C, Application A " +
                                "WHERE C.serial# = A.serial# AND " +
                                        "C.bid=0;";