Forum Discussion
CharlesHarold
7 years agoOccasional Contributor
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".
Related Content
- 3 months agoasantev2
- 2 years agozokirsalomov
- 3 years agolydeeea
Recent Discussions
- 19 hours agogroovyguy