DSXchange

I am trying update using user defined query as below.It is not really updating and throwing a warning.

UPDATE #MVS_SCHEMA#.exchg_45day_to_55day
SET AMT_PAR_AVAIL_45DAY=?,
AMT_PAR_EXCHG_55DAY=?,
RATE_AVAIL_45DAY=?,
RATE_EXCHG_55DAY=?,
DT_LST_UPDT=?,
ID_USER_LST_UPDT=?
WHERE
NBR_CUSIP_55DAY=?
AND NBR_CUSIP_45DAY=?
AND NBR_POOL_45DAY=?
AND NBR_POOL_55DAY=?;

Following are warnings.

exchg_45day_to_55day,0: Warning: Ld_SAP_EXCHG_45DAY_TO_55DAY.exchg_45day_to_55day: NBR_CUSIP_55DAY = 3129BB875 NBR_CUSIP_45DAY = 31297QT82 AMT_PAR_AVAIL_45DAY = 2688632 AMT_PAR_EXCHG_55DAY = 0 NBR_POOL_45DAY = A35075 NBR_POOL_55DAY = BB8075 RATE_AVAIL_45DAY = 1 RATE_EXCHG_55DAY = 0 DT_CREATE = 2008-7-17 11:39:16.0 DT_LST_UPDT = 2008-7-17 11:39:16.0 ID_USER_CREATE = c16248 ID_USER_LST_UPDT = c16248

exchg_45day_to_55day,0: Error: At row 1, link "lnk_exchg_load"
Row rejected.
DBMS.CODE=-99999, SQLSTATE=22001, [IBM][CLI Driver] CLI0109E String data right truncation. SQLSTATE=2200

Please help me resolve this.

Lookup what error code CLI0109E means in DB2. It will help you to resolve this. It appears to relate to data larger than field size being sent.

Thanks Ray.I will try.