Disable Triggers for each connection

[noand24]

I read the article here http://www.ibm.com/developerworks/db2/library/techarticle/0211yip/0211yip.html
But may be exists another way in db2 9.7 using variables for example?

[Serge Rielau]

noand24 wrote:
> I read the article here http://www.ibm.com/developerworks/db2/library/techarticle/0211yip/0211yip.html
> But may be exists another way in db2 9.7 using variables for example?

yes. Starting in DB2 9.5 you can use a global variable.
E.g. (untested, may have sntax errors but you get the idea...)

CREATE VARIABLE triggersdisabled INTEGER DEFAULT 0;
GRANT READ ON VARIABLE triggersdisabled TO PUBLIC;
GRANT WRITE ON VARIABLE triggersdisabled TO USER itsme;

CREATE TABLE T(c1 INT);
CREATE TRIGGER trg BEFORE INSERT ON T REFERENCING NEW AS N FOR EACH ROW
WHEN (triggersdisabled = 0)
SET c1 = -c1;

Now itsme can SET triggersdisabled to 1 (true) for its connection.
everyone else will keep them.

Cheers
Serge

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab