the second test select worked of course.
>Ed Eden wrote: >> Entering sub doQuery >> query: select * from certificate where (req_key like ?) order by cert_key >> bind_values: 256 >> prepare statement >> statement nr.: 2 .> prepare failed >> query: select * from certificate where (req_key like ?) order by cert_key >> returned errorcode: 42884 > > So this is the crashing SQL-query. Does DB2 have a problem with like and > numeric fields? Perhaps I should ask our DB2-specialists. Any other ideas? > > Can you test the following queries on your database? > > select * from certificate where (req_key like 256) order by cert_key > select * from certificate where (req_key = 256) order by cert_key > > If the second query works and the first query fails then I can build a > patch for the problem. > > Michael
------------------------------------------------------- This SF.net email is sponsored by: Microsoft Visual Studio.NET comprehensive development tool, built to increase your productivity. Try a free online hosted session at: http://ads.sourceforge.net/cgi-bin/redirect.pl?micr0003en _______________________________________________ Openca-Users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-users
