We call a Stored Procedure on DB2 (AS400) from java using JDBC. Stored Procedure accepts seven input parameters and returns resultset of 17 columns. Data type of six input parameters is String and datatype of one input parameter is Integer.

If we specify input parameters such that it will retrieve less than 270 records in output, it works fine.

If we specify input parameters such that it will retrieve more than 270 records in output, it returns all records. It also return error -332.

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][AS] SQL0332N There is no available conversion for the source code page "0" to the target code page "819". Reason Code "1". SQLSTATE=57017