Unanswered: DB2 Select query with prepared statement.
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.