Can we create trigger like this in DB2

DBFinder · #1 (**permalink**) 02-17-09, 14:31

Hi all,

Is it possible to create trigger AFTER INSERT OR UPDATE
in DB2

Code:

CREATE TRIGGER DB2ADMIN.CLIENT_TOTALS
AFTER INSERT OR UPDATE 
ON TRANSACTION
REFERENCING NEW AS N OLD AS O
FOR EACH ROW
MODE DB2SQL

If not then is there a way around

Thanks

DBFinder

n_i · #2 (**permalink**) 02-17-09, 14:53

Quote:

Originally Posted by DBFinder

Is it possible to create trigger AFTER INSERT OR UPDATE

No.

Quote:

Originally Posted by DBFinder

If not then is there a way around

Create two triggers - on on insert, another on update.

DBFinder · #3 (**permalink**) 02-17-09, 14:58

Thanks,

Will do that.

Your clue was important to confirm myself

Thanks again
DBFinder

stolze · #4 (**permalink**) 02-17-09, 15:44

Have a look at the syntax diagrams in the manual. If you can not map your syntax to the diagrams, then your syntax is not permissible.

DBFinder · #5 (**permalink**) 02-18-09, 12:46

Thanks Stolze,

One senior had clued me the code that seemed odd to me.
My best trust is dbforums where yourself , n_i , ARWinner are few to mention.

Thanks again
DBFinder

n_i · #6 (**permalink**) 02-18-09, 13:09

Quote:

Originally Posted by DBFinder

One senior had clued me the code that seemed odd to me.

Let me guess - that person has Oracle background, not DB2.

Internet Services

Web Development

Digital Marketing

Consumer Tech