|
View previous topic :: View next topic
|
| Author |
Message |
sivasaras
New User
Joined: 29 Sep 2007
Posts: 93
Location: chenna/i-
|
|
|
|
Hi,
From the front end java side they are trying to add a new row, while
adding they are getting error as the given attributes already exists.
the error code we got in Mainframe for the stroed procedure is
-803 INSERT SQL - DB2 ERROR
NAME:SG: DSNXRINSSQLERRD: -110
SQLWARN: SQLSTAT: 23505
while inserting a duplicate row we get this error.but i want to find which index is causing this error.
thanks
saras |
|
| Back to top |
|
 |
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
| Quote: |
-803 AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE THE INDEX IN INDEX
SPACE indexspace-name CONSTRAINS COLUMNS OF THE TABLE SO NO TWO
ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING
ROW IS Xrid |
so probably indexspace-name = DSNXRINS
| Code: |
| select * from sysibm.sysindexes where indexspace = 'DSNXRINS' |
|
|
| Back to top |
|
|
sivasaras
New User
Joined: 29 Sep 2007
Posts: 93
Location: chenna/i-
|
|
|
|
hi,
when i ran the query i got only NAME field.
Thanks
Saras |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
what query?
may have to increase your output record size in spufi
and of course you have to shift right.
names can be 128 chars.
sure glad it is time to go home. |
|
| Back to top |
|
|
sivasaras
New User
Joined: 29 Sep 2007
Posts: 93
Location: chenna/i-
|
|
|
|
Hi,
Thanks for the information.
when i ran that query i got all the columns with zero rows displayed.
Thanks
Saras |
|
| Back to top |
|
|
|
|
