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

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

Question Posted / kk

3 Answers
7927 Views
I also Faced
E-Mail Answers

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

Why journalling is compulsory before commitment control?

1 Answers

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

0 Answers

Q.1 how to implement the commitment control. 2.how to control commitment control from external program.

7 Answers IBM,

how to see number of logical files depending on a pf?...can we declare more than 20 logical files from a single pf? is it possible

4 Answers ocbc,

If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.

2 Answers

How to add a field to a PF and compile it without loss of data?

7 Answers

How to know logical file belongs to which physical file without source?

1 Answers

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

0 Answers

Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?

4 Answers IBM,

How to insert more than one record to a pf at a time?(Bulk insert to a pf)

9 Answers

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

3 Answers

How to retrieve a physical file after deleting that ? what is keyword used for that....??

6 Answers

For more DB400 Interview Questions Click Here