Srinivasan,
Check the below descriptiom :
SQL0302N
The value of a host variable in the EXECUTE or OPEN statement is too
large for its corresponding use.
Explanation
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 NUL character is missing from the C language
NUL-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 or an incorrect SQLLEN value in an SQLDA on an EXECUTE or OPEN
statement.
The statement cannot be processed.
User response
Ensure that the input host variable value is the correct type and
length. If the input host variables supply values to parameter markers,
match values with the implied data type and length of the parameter
marker.
Federated system users: for a pass-through session, determine what data
source is causing the error (see the Troubleshooting Guide for
procedures to follow to identify the failing data source). Examine the
SQL dialect for that data source to determine which specific restriction
has been violated, and adjust the failing statement as needed.
sqlcode: -302
sqlstate: 22001, 22003
Regards,
Rajesh Chandramohan
Offshore UDB DBA Team
180-066-62388 x 13311/37/97
Please note that the ODC UDB Operations work on a shift rotation basis,
therefore any ongoing communication generated from this e-mail should
have #ODC UDB or #DBA-UDB included in order to maintain a prompt
response.
-----Original Message-----
From: Srinivasan
[mailto:db2udbdba-ezmlmshield-x78115038.[Email address protected]
Sent: Wednesday, April 23, 2008 10:59 PM
To: LazyDBA Discussion
Subject: Re: sqlcode:-302 and sqlstate:22001
We are getting error while doing insertion,can anyone pls suggest
insert into DTD_D_OBJECT_DATA_ACTIVITY (String_Uda_Value, OBJECT_ID,
LogDate, Uda_Name, EVENTID) values (?, ?, ?, ?, ?)
INFO STDOUT -
Hibernate: insert into DTD_D_OBJECT_DATA_ACTIVITY (String_Uda_Value,
OBJECT_ID, LogDate, Uda_Name, EVENTID) values (?, ?, ?, ?, ?)
ERROR util.JDBCExceptionReporter - DB2 SQL
error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null
ERROR .AbstractFlushingEventListener - Could
not
synchronize database state with session
org.hibernate.exception.DataException: could not insert:
ERROR util.JDBCExceptionReporter - DB2 SQL
error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null
ERROR .AbstractFlushingEventListener - Could
not
synchronize database state with session
org.hibernate.exception.DataException: could not insert:
-----------------------------------------
This communication may contain proprietary and/or confidential
information and is the property of The Western Union Company or its
affiliates. If you are not the intended recipient, you are hereby
notified that any use of the information contained in or transmitted
with the communication or dissemination, distribution, or copying of
this communication is strictly prohibited. If you have received this
communication in error, please notify the Western Union sender
immediately by replying to this message and delete it from your
computer.
---------------------------------------------------------------------
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
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
This message is intended only for the personal and confidential use of the designated recipient(s) named above. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communication is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product, an official confirmation of any transaction, or as an official statement of Lehman Brothers. Email transmission cannot be guaranteed to be secure or error-free. Therefore, we do not represent that this information is complete or accurate and it should not be relied upon as such. All information is subject to change without notice.
--------
IRS Circular 230 Disclosure:
Please be advised that any discussion of U.S. tax matters contained within this communication (including any attachments) is not intended or written to be used and cannot be used for the purpose of (i) avoiding U.S. tax related penalties or (ii) promoting, marketing or recommending to another party any transaction or matter addressed herein.
DB2 & UDB email list listserv db2-l LazyDBA home page