Hey Dean,
I noticed you're certified in DB2 v9. What books or training did you
use?
I'm certified in v6, v7 and v8 and I would like to get this V9 Cert done
as soon as possible.
By they way, I like your web site. Your quote "There are a lot of
useful tools for the DB2/LUW DBA on www.ibm.com but finding what you
need can be frustrating and time consuming"
So true, I don't know who IBM hired to do their web site search engine
but they totally screwed up when they fired Google.
"Too often I see large companies become a breeding ground for total
chaos...like an aggressive cancer"
--John Kruger
-----Original Message-----
From: Dean Compher
[mailto:db2udbdba-ezmlmshield-x94451801.[Email address protected]
Sent: Wednesday, December 20, 2006 8:49 AM
To: LazyDBA Discussion
Subject: Re: SQL0302N The value of a host variable in the EXECUTE or
OPEN statement is too large for its corresponding use. SQLSTATE=22001
sqlstate = 22001
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_WI
D,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
---------------------------------------------------------------------
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