DB2 ignore errors on variable length

See more:

SQL

Parameter

DB2

Hi,

I wrote a lot of parametrized queries where parameters are inserted by the user. If the user inserts strings longer than the field where parametrized value is referring to, DB2 throws a SQL0302N error.

There is a way to avoid it?

Example:

Create Table Foo (Code Char(3) Not Null, Descr Varchar(50));

PreparedStatement ps = new PreparedStatement(
     "Select * From Foo Where Code = ? Or Descr = ?");
ps.setString(1, txtInput.value);
ps.setString(1, txtInput.value);

If the parametrized value is bigger than 3 characters then first parameter throws an exception.

What I have tried:

The use of «= TRIM(?)» or «Like ?» instead of «= ?» avoids the error.
But I'd like fix it modifyng the connection string. In this way I will be sure that error won't thrown any more, even if I forget to fix some queries.