Greetings,
In the DB2 Messages Volume 2 I found that the error is likely caused by
one of the following:
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 too large.
The terminating NUL character is missing from the C language
NUL-terminated character string host variable.
I believe that these mean that the length of the variable defined in your
application is defined bigger than the column in the DB2 table or a string
is not terminated with a NUL in a C program. More information can be
found at:
ftp://ftp.software.ibm.com/ps/products/db2/info/vr82/pdf/en_US/db2m2e81.pdf
Regards,
Dean Compher
Certified IT Specialist - Information Management
IBM Certified Database Administrator - DB2 9 DBA for Linux, UNIX and
Windows
Phone: 801-328-6815
e-Mail: [Email address protected]
www.db2Dean.com
"Prachi Sharma " <db2udbdba-ezmlmshield-x6666075.[Email address protected]
12/20/2006 06:00 AM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
SQL0302N The value of a host variable in the EXECUTE or OPEN statement is
too large for its corresponding use. SQLSTATE=22001 sqlstate = 22001
HI ALL
When i am running ETL(Extraction Transform Load) on DB2 OLAP
some of the tasks are failing with the following error Code:
WRT_8036 Target: W_LST_OF_VAL_G (Instance Name: [W_LST_OF_VAL_G])
WRT_8038 Inserted rows - Requested: 10140 Applied: 10140
Rejected: 0 Affected: 10140
WRITER_1_*_1> Tue Dec 19 04:23:15 2006
WRITER_1_*_1> WRT_8229 Database errors occurred:
[IBM][CLI Driver][DB2/AIX64] SQL0302N The value of a host variable in
the EXECUTE or OPEN statement is too large for its corresponding use.
SQLSTATE=22001 sqlstate = 22001
Database driver error...
Function Name : Execute
SQL Stmt : INSERT INTO
W_LST_OF_VAL_G(DATASOURCE_NUM_ID,ETL_PROC_WID,INTEGRATION_ID,NAME,ROW_WID,TYPE,VAL,HIGH,LOW,ORDER_BY)
VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[IBM][CLI Driver][DB2/AIX64] *SQL0302N The value of a host variable in
the EXECUTE or OPEN statement is too large for its corresponding use.
SQLSTATE=22001 sqlstate = 22001*
Database driver error...
Can anyone please help me on this
Thanks
Prachi
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page