|
View previous topic :: View next topic
|
| Author |
Message |
student_mf
New User
Joined: 15 Jun 2007
Posts: 23
Location: pune
|
|
|
|
hi when i run a job i got duplicate error
SQLCODE = -803, ERROR: AN INSERTED OR UPDATED VALUE IS
INVALID BECAUSE INDEX IN INDEX SPACE CBRRSRX2 CONSTRAINS
COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE
VALUES IN THOSE COLUMNS. RID OF EXISTING ROW IS X'0000000234.
iam new to db2 and i used SELECT * FROM SYSIBM.SYSINDEXES WHERE TBNAME='tablename'; and i got the indexname index space name and my test table has 52 rows and how to browse index cols to identify which col is causing dupliacte error.
any suggestions thanks. |
|
| Back to top |
|
 |
alluri12
New User
Joined: 15 Aug 2006
Posts: 44
Location: Virginia, USA
|
|
|
|
If you know the index name then go to
| Code: |
select * from SYSIBM.SYSKEYS
where ixname = indexname |
Now you can see all the columns for that index |
|
| Back to top |
|
|
student_mf
New User
Joined: 15 Jun 2007
Posts: 23
Location: pune
|
|
|
|
| alluri12 wrote: |
If you know the index name then go to
| Code: |
select * from SYSIBM.SYSKEYS
where ixname = indexname |
Now you can see all the columns for that index |
thanks it worked . |
|
| Back to top |
|
|
|
|
