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

提问者

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

相关问题

问题状态

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