If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

EXECUTE or OPEN statement is too large for its corresponding use

Started by pooja, 21 Apr 2010 11:40:11 AM

Previous topic - Next topic

pooja


[DB2] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. SQLSTATE=22001

the_xxx

The value of an input host variable was found to be too large for its
use in the SELECT, VALUES, or prepared statement. One of the following
occurred:
The corresponding host variable or parameter marker used in the SQL
statement is defined as string, but the input host variable contains a
string that is too long.
The corresponding host variable or parameter marker used in the SQL
statement is defined as numeric, but the input host variable contains a
numeric value that is out of range.
The terminating NULL character is missing from the C language
NULL-terminated character string host variable.
Federated system users: in a pass-through session, a data
source-specific restriction might have been violated.
This error occurs as a result of specifying either an incorrect host
variable.