Triggers

dvtdbd · #1 (**permalink**) 03-03-05, 12:04

Next trigger is not valid:

CREATE TRIGGER capuntes_upd_2
AFTER UPDATE OF cuenta, codaux, apteid, moneda ON capuntes
REFERENCING NEW AS nxt OLD AS prv
FOR EACH ROW MODE DB2SQL
WHEN (prv.cuenta != nxt.cuenta)
BEGIN ATOMIC

CALL capuntes_cimpcont(prv.apteid, nxt.cuenta);

END

SQLSTATE: 42601, SQLERRMC: END-OF-STATEMENT;.apteid, nxt.cuenta);<delim_semicolon>

Which is the problem?

jsp2999 · #2 (**permalink**) 03-03-05, 12:36

I don't think you can call stored procedure from trigger!!!

sathyaram_s · #3 (**permalink**) 03-03-05, 14:01

If you are on LUW V8, you can issue a SP call from a trigger ...
IIRC, call SPs from triggers are valid from V7 on ZOS

What platform are you on ?

bmujeeb · #4 (**permalink**) 03-03-05, 18:24

Sathyaram,

Is this not version 8.2.

regards

Mujeeb

sathyaram_s · #5 (**permalink**) 03-04-05, 02:39

Mujeeb, thanks for pointing out ...
DB2 LUW supports call of SP from trigger from V8.2

Cheers
Sathyaram

dvtdbd · #6 (**permalink**) 03-04-05, 06:43

Thanks.

I have confirmed that a trigger can not call a stored procedure in the book titled DB2 Universal DataBase in Application Development Environments.

So it is possible from DB2 LUW 8.2. What about AS/400 platform?

Internet Services

Web Development

Digital Marketing

Consumer Tech