Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Programming > Database Programming > What are triggers?

What are triggers?

In: Database Programming, Technology [Edit categories]

Answer:

Triggers are an action that is performed is a condition is met within the code.

In this example, "TRIG56" will perform this action:

After a row is inserted into TABLEZZZ, if the row is <=50 then
insert the same row into TABLEYYY. If the condition/value is not
met, the row will not be inserted.

You can do a "BEFORE" trigger also. Triggers are code that must be compiled. You can also "disable" a trigger if you are doing an import into the tables for faster insertion. However, the inserts will have to be done into both tables because TABLEYYY will not be populated from the trigger because it is disabled.

CREATE TRIGGER trig56 AFTER INSERT ON tableZZZ REFERENCING NEW AS insertedRow FOR EACH ROW WHEN (insertedRow.a <= 50) BEGIN INSERT INTO tableYYY VALUES(:insertedRow.b, :insertedRow.a); END trig56; . run;

Note: There are comments associated with this question. See the discussion page to add to the conversation.

First answer by Ppyles. Last edit by Ayvsuresh 9. Contributor trust: 1 [recommend contributor ]. Question popularity: 13 [recommend question].

[report abuse]

Can you answer these Database Programming questions?

	What is data portability?	Answer it!
	What is the future of databases in web information systems?	Answer it!
	What is the strength of the database approach?	Answer it!
	What are the advantages and disadvantages of Internet Download Manager?	Answer it!
	Why use a database query tool?	Answer it!

Relevant answers:

Where is the left trigger and right trigger?
On most emulators, a and s.
What is trigger?
A trigger is defined for and connected to a RDBMS table. A trigger can be defined to do a particular job (typically insert audit records in another table or perform some validations) whenever the...
What is the trigger?
A trigger is nothing but a database event. It is implicitly evoked whenever a database event like insert, update, delete, shutdown, etc occurs. There are 12 different types of database triggers. They...
What is a trigger?
Trigger is a statement that excute automatically as a side effect of modification to the database.
Level trigger and edge trigger?
Level triggering means the specified action occurs based on the steady state value of the input. An SR flip flop is an example of this - so long as S is true, the flip flop will stay set. Edge...