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

What is open data path? And what is the difference between access path and open data path?

1 Answers  


wirte a simple program for read file in cl

2 Answers   Active Brains,


what is the purpus of the chain and setll and setgt ?

2 Answers   Four soft,


Last statement of any RPG pgm is LR?

5 Answers  


Last statement of any rpg program is lr?

0 Answers  






I had created one physical file tell me command to enter data in to?

1 Answers  


what is the difference between adding keys & constraints into a phisical file

4 Answers   HSBC,


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

1 Answers   HCL,


how to update physical files using normal logical file

4 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,


How to find the list of source physical files in a library?? Is there any way to get a list??

5 Answers   Infosys,


How to know the particular record in pf with out reading?

0 Answers  


Categories