REsolving SQLCODE -302 in IBM DB2

[amarhegde]

When u perform the SELECT operation,

Sometimes u get this error Code

java.rmi.Remote Exception: ; nested exception is:
javax.ejb.EJBEx ception: nested exception is:
com.ibm.db2.jcc .b.SqlException : DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001,
SQLERRMC: null


SQLCODE: -302 occurs when the host variable size is too large .

Can any one provide me solution to the above problem.

[rajendhar]

com.ibm.db2.jcc .b.SqlException : DB2
i also geting same problem pls any ne provide solutions