Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What are Triggers?

Answers were Sorted based on User's Feedback



What are Triggers?..

Answer / prima krishnan,escubetechnolog

Triggers are user-written programs that are associated with
database tables. You can define a trigger for update,
delete, and insert operations. Whenever the operation takes
place, regardless of the interface that is changing the
data, the trigger program is automatically activated by DB2
database and executes its logic. In this way, complex rules
can be implemented at the database level, totally
independent from the application layer......

Is This Answer Correct ?    13 Yes 2 No

What are Triggers?..

Answer / newbiezhang

trigger is a approach to catch the Data before or after the
Data manipulation performed. we can use triggers to valid
data, save the data change log, or do other manipulation
base on our business logic.

Is This Answer Correct ?    8 Yes 1 No

What are Triggers?..

Answer / sujanindian

Triggers is a self contained set of transact executable
statements which can be invoked during the operations such as
insert,update,delete can be performed in a database file.
We can able to add trigger in a physical file :
ADDPFTRG
to remove a trigger : RMVPFTRG

In the case of SQL/400 we can create trigger by ....

>>STRSQL
>>CREATE TRIGGER TRG_Name
after INSERT/DELETE/UPDATE On PF1
Insert Into PF2 Values ('RECORDS DELETED IN PF1')
>>Delete FROM PF1 Where Recordno = 10
>>SElect * FROM PF2.

In the above code, the records in the PF1 is deleted , at
once the trigger trg_name is fired and the given insert
statement is activated in pf2.

Is This Answer Correct ?    6 Yes 0 No

What are Triggers?..

Answer / mithun

Triggers are user programs that are called when an operation
(Insert,update,delete)occured in a database table. By the
ADDPFTRG command in CL we attached a database pf with the
trigger program.Whenever this PF is changed, the trigger
program is call.

Is This Answer Correct ?    6 Yes 0 No

What are Triggers?..

Answer / ravi shankar porwal

Trigger are events that are fired automatically whenever
there are any changes made to the database file.The actions
that may cause of firing the events are - insert, update or
delete operations on database files.

Is This Answer Correct ?    3 Yes 1 No

What are Triggers?..

Answer / yogesh

Trigger is an automatic action of databse which invoke a
program to perform based on perticular event at perticular
time

There are six type of triggers:
Insert + Before
Insert + After
Update + Before
Update + After
Delete + Before
Delete + After

Is This Answer Correct ?    2 Yes 0 No

What are Triggers?..

Answer / cyjil

TRIGGERS ARE SOME RESTRICTIONS IN A P.F.. TO PROTECT THE
DATAS AND PROTECT THE FILE ALSO....

Is This Answer Correct ?    4 Yes 3 No

What are Triggers?..

Answer / shipra jain

a trigger is automatically executed without any action required by the user .
a trigger defines an action the database should take when some database related event occurs.

Is This Answer Correct ?    1 Yes 0 No

What are Triggers?..

Answer / bala

Triggers are special kind of stored procedures that get
executed automatically when an INSERT, UPDATE or DELETE
operation takes place on a table.

Is This Answer Correct ?    1 Yes 0 No

What are Triggers?..

Answer / sonam

Trigger Fire when any event occur with a particular application.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More IBM AS400 AllOther Interview Questions

What is Sub-System?

1 Answers  


What is class of service ?

1 Answers  


WHAT IS ACTIVATION GROUP IN ILE?

10 Answers   Accenture, HSBC, TCS,


How to convert a spool file to PDF file in AS400?

0 Answers  


write the SQL statement to retrieve the 2nd Highest salary ammount(File Name="EMPLOY",Field Name="SALARY")

6 Answers   Bally Technologies, Cognizant, Vertex,






how can you detect overflow for a print program that prints multiple lines per cycle?

1 Answers   IBM,


what are the different opcodes available in rpg for database access ?

1 Answers   IBM,


which type of object is used in db2/400?

0 Answers   IBM,


name few ibm supplied libraries?

2 Answers   IBM,


What is SFLPAG

1 Answers  


What are the different types of messages in CL?

1 Answers  


what is default data type for the fields(sub fields) defined in data structures in rpg?

2 Answers   IBM,


Categories