COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: pooja on 21 Apr 2010 11:40:11 AM

Title: EXECUTE or OPEN statement is too large for its corresponding use
Post by: pooja on 21 Apr 2010 11:40:11 AM

[DB2] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is too large for its corresponding use. SQLSTATE=22001
Title: Re: EXECUTE or OPEN statement is too large for its corresponding use
Post by: the_xxx on 21 Apr 2010 03:59:01 PM
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.