MVSFORUMS.com

[csk]

Hi,

I am having a situation wherein, our online program is processing an INSERT query into a table say TALTAPN.
During a related online transaction, the sqlcode for the above insert query operation is being thrown as -723.

(Note - Triggers have been defined for this table )
Error type - DB2, Error code = -723,
The description available is - "An Error occurred in a triggered sql statement in trigger WW.GPLAPN3, section number. Information returned: sqlcode -443, sqlstate 38H01 and message tokens MQSEND, MQSND4,rc=110:amSesOpen

And when looked into the trigger, it had the following details -

CREATE TRIGGER WW.GPLAPN3 AFTER INSERT ON WW.TALTAPN
REFERENCING NEW AS NEW FOR EACH ROW MODE DB2SQL
SELECT DB2MQ2C.MQSEND ('CNNCL_ITEM',
'DB2.TRIGGER.POLICY', 'I' ||'TALTAPN '
||NEW.REF_NO||NEW.ALT_APN , NEW.REF_NO ) FROM
SYSIBM.SYSDUMMY1

Can someone help in finding what could have caused this abend ?

Thanks,
csk

[CICS Guy]

The manual says Programmer Response: Contact your Database Administrator to determine why the trigger named in the message received the error.

[dbzTHEdinosauer]

I believe the Create Trigger that you posted is incomplete.
Where is the SQL terminator ';' and an END keyword?

But then again, what vsn of db2 are you using?
_________________
Dick Brenholtz
American living in Varel, Germany