What are Triggers?
- 14 Answers
- 25939 Views
- Ordain Solutions, Seabus Solutions, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is the difference between sflclr and sflinz?
what the purpose of ovrdta, ovrata keywords?
how can you execute a command from within an rpg program without calling a clp program?
what is the use of jdftval in join logical file?
how can you detect and handle a record lock situation?
how will you find a string using pdm?
what are the important factors in error message subfile ?
in conjunction with what other keyword must ovrdta and ovrata be used?
Difference Between Call & Sbmjob?
what is message subfile?
How can we update a specific field in RPG?
how can you detect overflow for a print program that prints multiple lines per cycle?
i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.
What is the difference between iter and do? We know both are used to execute set of statements repeatedly, but what is the main difference?
why is the declare cursor statement is used for?
