What are Triggers?
- 14 Answers
- 28183 Views
- Ordain Solutions, Seabus Solutions, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 ? | 14 Yes | 2 No |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Answer / sonam
Trigger Fire when any event occur with a particular application.
| Is This Answer Correct ? | 1 Yes | 0 No |
when would you prefer logical file than opnqryf?
how can we view the entire objects and its types in a pgm?
Please give me the code for A=A+1 in cl program?
What is the use of OVRDBF ?
What the purpose of the keywords FIFO, LIFO, FCFO?
How are the objects stored on AS/400?
any one have give AS400 study material? pls pass it to gopalsai789@gmail.com
I am fresher 2009 passedout.can you pls explain me what is AS400 and where it can be used and how about growth in the position as well as salary, whether it is a programming language or else?
what is sessional error or divice error in rpg IV?..when will it happens...Give few examples?
Good morning my experts.Im kuppi.im working as a software trainee on AS/400 technology.i have also joined with ibmi5 team.im trying to convert date with cl/400 coding.I have taken 2 parameters(like date and date types). A. If suppose date type is j,Now i want to convert date to *MDY format B. if date type is M,now i want to convert date to *JUL format C. sending a Program message with the value of converted date.
Hi All, Can any one give me a suggestion for below prob One job is in MSGW due to decimal dara error and I find out stmt error and Value in DMUP. but my file has millions of records.So how can i find out on which record the error was occured....?
what is the command to know how many lf are related to a pf?
RPG400 
