Error "SQL030ZN The value of a host variable in the EXECUTE or OPEN statement is too large for it (4307387)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error "SQL030ZN The value of a host variable in the EXECUTE or OPEN statement is too large for it
Description

When calling a stored procedure via the editor:
'CALL owner.procname(%OPTION, @BEG_POOL, @END_POOL, @RTN_CODE)'
the following error is displayed:
"ERROR [22001] [IBM][DB2] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use..."
Cause

Invalid value was input for one of the parameters
Resolution

Input correct values for the parameters.
Additional Information

See the following link for an explanation of this DB2 error message:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=%2Fcom.ibm.db2.luw.messages.sql.doc%2Fdoc%2Fmsql00302n.html

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title