How can we know that a trigger has been added on a PF? and
what is the purpose of adding a trigger?

Answers were Sorted based on User's Feedback



How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger..

Answer / sujata

Do the DSPFD then you will get to see that triggers has been
added.

We add triggers to check particular action. e.g If you want
to add record then one program will keep watch that record
addition is tried and do the set of defined actions in the
trigger program.

Is This Answer Correct ?    13 Yes 0 No

How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger..

Answer / vj

Triggers are useful for
1. keeping audit trails
2. for detecting exceptional conditions
3. for maintaining relationships in the database.

Is This Answer Correct ?    1 Yes 0 No

How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger..

Answer / karu

sujata can you plz explain it with the help of example program.........

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB400 Interview Questions

I have a PF with out any data but the dependent LF is having data?

1 Answers   HCL,


how to restrict upon adding the data for field reference file in DB400

1 Answers  


I have a pf, it contains 5 members, how to access particular member data from logical file?

0 Answers  


one physical file can have how many max of logical files? what is the primary file?

3 Answers   Four soft,


Suppose I have a pf,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in pf?

0 Answers  






Why journalling is compulsory before commitment control?

1 Answers  


WHAT IS THE DIFFERENCE BETWEEN 'COLHDG' AND 'ALIAS'?

5 Answers   Accenture,


How can i retrieve city while my i have one field address length 60 but i don't know what where is city in this field ?

4 Answers  


what is the intractive job? what is the batch job ? how to change the batch job to interactive job?

2 Answers   Four soft,


How to find the list of source physical files in a library?

0 Answers  


I want to change the attribute of field or want to add new field in existing PF but condition is format level identifier should not change, is it possible?

9 Answers   Mind Tree, TCS,


CRTDTA AND CRTARA should be used along with?

2 Answers  


Categories