Trigger start/stop via ODBC

[bobo123]

Please, anybody could give me a sample, how to remove (or start) trigger on DB2 via ODBC ?
I tried:
sqlexec(Handle,"RMVPFTRG FILE(DPNDEV/FESW00)&quot
This returns an error
then:
sqlexec(Handle,"CALL 'RMVPFTRG FILE(DPNDEV/FESW00)'&quot
gives an error too.

Thanks Bobo

 

[ARWinner]

You cannot execute a trigger, from ODBC or SQL. They are executed automatically by DB2 whenever an update, insert, or delete is performed (depends on the type of trigger).

You can remove *drop) the trigger with the following SQL:

DROP TRIGGER myTrigger;

HTH

Andy