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.
Updating records in DB2 mainframe using DB2/UDB API stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: