db2 v9.1更新数据报错

表结构如下:create table cbankinterest
(
    workdate   varchar(8)       not null,
    bankid       varchar(12)     not null,
    product     decimal(15,2)  default 0.00  not null,
    interrest_rates   decimal(15,2) default 0.000000 not null,
    interest     decimal(15,2)
);
create unique index cbankinterest_idx1 on cbankinterest (workdate,bankid);

执行update cbankinterest set bankid='235013053027' where bankid='133013051003'
DB20134E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command .During SQL processing it returned:
SQL0803N One or more values in the INSER statement ,UPDATE statement ,or
foreign key update caused by a DELETE statement are not valid because the
table "IDDS.CBANKINTEREST" from having duplicate values for the index key.
SQLSTATE=23505
求助此问题如何处理
参与4

3同行回答

vodrenvodren技术支持信雅达
多谢找到原因了显示全部
多谢找到原因了收起
系统集成 · 2015-09-08
浏览1087
zsj2002zsj2002数据库管理员澳門大豐銀行
"IDDS.CBANKINTEREST" from having duplicate values for the index key.,説的很清楚了 duplicate values显示全部
"IDDS.CBANKINTEREST" from having duplicate values for the index key.,説的很清楚了 duplicate values收起
银行 · 2015-09-07
浏览1118
wolaos123wolaos123项目经理澳美制药
select * from IDDS.CBANKINTEREST where bankid='235013053027'显示全部
select * from IDDS.CBANKINTEREST where bankid='235013053027'收起
医院 · 2015-09-07
浏览1081

提问者

vodren
技术支持信雅达
擅长领域: 数据库服务器前置系统

问题状态

  • 发布时间:2015-09-07
  • 关注会员:1 人
  • 问题浏览:3049
  • 最近回答:2015-09-08
  • X社区推广