Updating records in DB2 mainframe using DB2/UDB API stage

[narsingrp]

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.

[ray.wurlod]

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.

[narsingrp]

Thanks Ray.I will try.