What return code will SQLCODE will have?

[Gurugars]

Friends -

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

Many Thanks in advance!

[dbzTHEdinosauer]

the -723 refers to the trigger encountering a problem during its activities.
the -913 (WTH is -903? learn to be more accurate!)
with an reason code of 00C900BA - find it here
with a type code of 00002002 - tablespace write class (also found in above linked pdf)

probably your table pqrs DPNAM01Q.MWDL001Q

now your question:

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.

you did not get a -903. all the info is provided in the error message:

Code: Select all

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,