I happened to come across one problem today.
There is a table called ABCD. When I'm trying to update this table in background a trigger will be triggered to update another table PQRS.
Now, I encountered -903 error, could some one please tell me because of which event I got -903? ABCD update or Background triggered event PQRS update.
I am pasting the complete error message -
Code: Select all
SQLCODE: -723
DB2 ERROR OCCURRED...
LAST ROUTINE: 700A-TSUPDATE-WFST
DSNT408I SQLCODE = -723, ERROR: AN ERROR OCCURRED IN A TRIGGERED SQL STATEMENT IN TRIGGER DBAXAT.TRWDHUA1. INFORMATION
RETURNED: SQLCODE -913,
SQLSTATE 57033, MESSAGE TOKENS 00C900BA,00002002,DPNAM01Q.MWDL001Q, SECTION NUMBER 2
DSNT418I SQLSTATE = 09000 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRUID SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -150 13172746 0 13228485 -673636351 12714050 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF6A' X'00C9000A' X'00000000' X'00C9D9C5' X'D7D92001' X'00C20042' SQL DIAGNOSTIC
INFORMATION