We've been trying to set up a Trigger that executes a UDF that calls a
program that does a simple SQL statement and keep getting the
when we execute the trigger:
SNT408I SQLCODE = -723, ERROR: AN ERROR OCCURRED IN A TRIGGERED SQL
IN TRIGGER PRODDATA.TRIGGRNM, SECTION NUMBER 2.
INFORMATION RETURNED: SQLCODE -430, SQLSTATE 38503, AND
FUNCTION ,PRODDATA.UDFNAME ,Z
SNT418I SQLSTATE = 09000 SQLSTATE RETURN CODE
SNT415I SQLERRP = DSNX9CAC SQL PROCEDURE DETECTING ERROR
SNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
SNT416I SQLERRD = X'00000000' X'00000000' X'00000000'
If we take the SQL statement out of the cobol program the trigger
executes without problems. This is the SQL in the program and a row
WHERE EMP_NBR = '123456789'
Is there something obscure we are missing here? Let me know if I can
supply more info.