Hi Guys,
I have a problem with DB2 when I am executing a select query which takes parameters with prepared statement. In the example below, 4th parameter has column size of 8, but i am giving string longer than that. I know it is not right but i dont want db2 to give an exception for that. Instead, I am expecting a 0 result. If i run the sql directly without using prepared statement it works fine and returns 0 result. Is it possible to override this behavior of db2 driver by may be setting a system parameter?
Thanks for the answers in advance.



PreparedStatement stmt = conn.prepareStatement(strQuery);
stmt.setString(4, "71111111111111111111111111111111111111111");
ResultSet query = stmt.executeQuery();


Gets the exception:
Exception in thread "main" com.ibm.db2.jcc.a.wm: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.51.90