Joined: 27 Jun 2001 Posts: 3081 Location: EmeriCon, LLC
SQL Messages and Codes wrote:
SQL0723N An error occurred in a triggered SQL statement in trigger
trigger-name. Information returned for the error includes SQLCODE
sqlcode, SQLSTATE sqlstate and message tokens token-list
Explanation: An SQL statement in the trigger trigger-name has failed during execution of the trigger. The sqlcode, sqlstate and message token
list (each token is separated by the vertical bar character) are provided. The message tokens may be truncated. See the corresponding message for the sqlcode for further explanation of the error.
The trigger and the original SQL statement that caused the trigger to execute cannot be processed.
User Response: Check the message associated with the SQLCODE of the SQL statement that failed. Follow the action suggested by that message.
sqlcode: -723
I am not a DB2 person. Perhaps one of our posters who is more DB2 literate than me can shed some light on this one. I do not recall ever seeing this error before. If this error is continuing to occurr, I would open a PMR on this. _________________ John McDonald
RETIRED
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum