No cascade before

Breako · #1 (**permalink**) 08-06-11, 05:03

Hi,
What exactly does "NO CASCADE" mean before the definition of triggers?

I get the idea there's no cascading. But exactly what type of cascading is it referring to.

Thanks

tonkuma · #2 (**permalink**) 08-06-11, 06:02

IBM DB2 9.7 for Linux, UNIX, and Windows SQL Reference, Volume 2
---> SQL statements ---> CREATE TRIGGER ---> Description

Quote:

NO CASCADE BEFORE
Specifies that the associated triggered action is to be applied before any
changes caused by the actual update of the subject table are applied to the
database. It also specifies that the triggered action of the trigger will not cause
other triggers to be activated.

Breako · #3 (**permalink**) 08-06-11, 06:33

Thanks a lot.

Internet Services

Web Development

Digital Marketing

Consumer Tech