Db2 Sql Error Code 104
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have ibm db2 sqlcode Meta Discuss the workings and policies of this site About Us
Sqlcode 103
Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with
Db2 Sql Error Code 805
us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n104.html like you, helping each other. Join them; it only takes a minute: Sign up com.ibm.db2.jcc.am.jo: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=?;;SELECT (, DRIVER=3.57.110 when trying to use .addBatch() [closed] up vote 0 down vote favorite Getting the following error when trying to use preparedstatement.addBatch() method. Error: com.ibm.db2.jcc.am.jo: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=?;;SELECT (, DRIVER=3.57.110 ... http://stackoverflow.com/questions/31171337/com-ibm-db2-jcc-am-jo-db2-sql-error-sqlcode-104-sqlstate-42601-sqlerrmc //code snippet con.setAutoCommit(false); for(int x = 0; x < 2; x++){ String val = "Test_" + x; insertPrepStmt = con.prepareStatement("INSERT INTO " + schema + ".TableA" + "VALUES(?, 'data')"); insertPrepStmt.setString(1, val); insertPrepStmt.addBatch(); //error happening here } //execute batch ... I'm getting connecto to database and database is a DB2 database. What can be the issue? java jdbc db2 prepared-statement share|improve this question asked Jul 1 '15 at 20:45 tony 801111 closed as off-topic by Brian Tompsett - 汤莱恩, talex, inquisitive_mind, Zakaria Acharki, mpromonet Sep 12 at 16:37 This question appears to be off-topic. The users who voted to close gave this specific reason:"This question was caused by a problem that can no longer be reproduced or a simple typographical error. While similar questions may be on-topic here, this one was resolved in a manner unlikely to help future readers. This can often be avoided by identifying and closely inspecting the shortest program necessary to reproduce the problem before posting." – Brian Tompsett - 汤莱恩, talex, inquisiti
New Topic programming forums Java Java JSRs Mobile Certification Databases Caching Books Engineering Languages Frameworks Products https://coderanch.com/t/620822/Websphere/error-likeSQLCODE-SQLSTATE This Site Careers Other all forums Forum: WebSphere I am getting error likeSQLCODE: -104, SQLSTATE: 42601 sachin pate Greenhorn Posts: 19 posted 3 years ago I am using following query INSERT INTO IIS.ADMIN_AUDIT(ACCESS_USER,ACCESS_TIME,ACCESS_TYPE,FUNCTION,ACTION_INFO) Martin Vajsar Sheriff Posts: 3752 62 I like... posted 3 years ago If this really is the db2 sql entire statement you're executing, then you're missing the values to insert - either the VALUES clause, or the SELECT clause. Harneet Singh Greenhorn Posts: 18 posted 3 years ago Agree with MARTIN , an INSERT statement is incomplete without the VALUES , unless you have not posted entire query. sachin db2 sql error pate Greenhorn Posts: 19 posted 3 years ago INSERT INTO IIS.AUDIT ( ACCESS_USER, ACCESS_TIME, ACCESS_TYPE ) VALUES ( 's12345', CURRENT TIMESTAMP, 'GET PART INFORMATION' ); console output as follows [9/29/13 13:41:22:806 GMT+05:30] 00000020 SystemErr R com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: ;;INFORMATION' );END-OF-STATEMENT [9/29/13 13:41:22:806 GMT+05:30] 00000020 SystemErr R at com.ibm.db2.jcc.b.id.e(id.java:1640) [9/29/13 13:41:22:806 GMT+05:30] 00000020 SystemErr R at com.ibm.db2.jcc.b.id.b(id.java:1197) [9/29/13 13:41:22:806 GMT+05:30] 00000020 SystemErr R at com.ibm.db2.jcc.c.fb.i(fb.java:234) [9/29/13 13:41:22:806 GMT+05:30] 00000020 SystemErr R at com.ibm.db2.jcc.c.fb.b(fb.java:50) Please let me i am doing wrong. Martin Vajsar Sheriff Posts: 3752 62 I like... posted 3 years ago Does this command work when run from an SQL client? And if it does, can you post the Java code that executes it? Post Reply Bookmark Topic Watch Topic New Topic Similar Threads Who am I? are you guys all aquiver? design question Word Games Completed SCEA(II/III) . i.e. Now all 4 Sun Java Certificat