Tuesday, August 25, 2015

DB2 SQL Error: SQLCODE=-723, SQLSTATE=09000

Error: DB2 SQL Error: SQLCODE=-723, SQLSTATE=09000, SQLERRMC=DB2WCS.STAGIATTRNONECMC;-420;22018;BIGINT, DRIVER=3.57.82
SQLState:  09000
ErrorCode: -723


What error mean : 

The SQLCODE=-723 error is telling us that an error occurred in the named trigger (in this case, the trigger is named DB2WCS.STAGIATTRNONECMC).

Refer : SQLCODE=-723

Furthermore, in the second part of the message, DB2 is telling us that the error that is occurring in the trigger is SQL0818N (SQLSTATE 22018)


Here mostly We are passing BIGINT value where it accept CHAR or some other thing.



No comments:

Post a Comment