Error: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2] SQL0723N
An error occurred in a triggered SQL statement in trigger
"SERDB.TRE07ADD". Information returned for the error includes SQLCODE
"-751", SQLSTATE "38003" and message tokens "STORED
PROCEDURE,SERDB.E06ADD ". SQLSTATE=09000, SQL State: 09000, Error Code:
-723



I am receiving the above error anytime I attempt an insert on table E07.
Upon insert, the trigger should call a stored procedure which updates
records on table E06. Both trigger and stored procedure were created
without error. The above message doesn't make any sense given the
situation, the reference manual doesn't help me either. I'm running V7.1
on Z/os. Would anyone have suggestions on what I should do? The stored
procedure works fine when testing under procedure builder.



Thank you,



Richard N. Olsen

Database Administrator

SC Department of Disabilities & Special Needs

Phone: (803) 898-9811

Email: [Email address protected]




DB2 & UDB email list listserv db2-l LazyDBA home page