Data driven testing-Data source JDBC
Hi All, I am implementing data driven testing in Ready API 1.9.0 by using data source as excel and JDBC both. I want to give input (number,date) values to SQL query in JDBC data source from excel d...
Forum Discussion
This link lists the IBM DB2 SQL Error Codes; clicking on one of them opens a new page with more information (I use this all the time when debugging my SQL):
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnmcj10/2.1.6?DT=20040216120637
The -104 code indicates there was something in the SQL that DB2 didn't recognize/expect; in the error string, look for the semi-colon and the unrecognized/unexpected something will be right before it, with possible fixes/alternatives after the semi-colon. In this case, "=nbr=and" is unrecognized; DB2 was expecting something like "AND".