iBatis/JDBC is all dynamic SQL -- at least not static in the DB2 sense. >From a DB2 doc on SQLSTATE 560B8:
The SQL statement cannot be executed because it was precompiled at a level that is incompatible with the current value of the ENCODING bind option or special register. I believe the term "precompiled" above can be interpreted as "prepared" from the JDBC point of view. On the other hand, the DB2 JDBC drivers do use some packages (e.g., SYSLN200) to handle dynamic SQL. So, I'd guess a problem with ENCODING or binding of DB2-supplied packages. Hope that helps... --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org