We are getting below error in one of our application team-
"File: Data MoverSQL error. Stmt #: 0 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] SQL0723N An error occurred in a triggered SQL statement in trigger "D2UHR01.PAYERN_N". Information returned for the error includes SQLCODE "23505", SQLSTATE "PSRA1VRI,000022520E" and message tokens "2". SQLSTATE=09000
Failed SQL stmt:UPDATE D2UHR01.PS_PAY_EARNINGS SET PAY_LINE_STATUS ='F' WHERE PAY_END_DT < '2011-05-15' AND PAY_LINE_STATUS NOT IN ('F','V')"
This is a probable error in one of the triggers of the table due to which the specified row is not getting inserted into the table.
1 - we do not do asap: we do as and when
2- you have been a member for almost 2 years, in that time there have been numerous posts telling members NOT to post attachments. If you are concientious about your job you would be reading all posts and you would have taken notice of this.
-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 X rid
so see which columns are in index PSRA1VRI (probably PAY_LINE_STATUS)
and if you're lucky you can see which row with
select * from D2UHR01.PS_PAY_EARNINGS A
where hex(rid(a)) = '000022520E'