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
7943 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

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

1 Answers

Where the QTEMP library will get created? if the the answer is QSYS, then howcome more than one job can create same library name(QTEMP) in QSYS? what is the uniqueness of QTEMP? For example, run the below command in different workstation WRKOBJ QSYS/QTEMP And take 8 in the option to check the description. both will have different info. so where(which LIB) exactly the QTEMP is stored?

2 Answers

How many maximum record format a logical file have?

0 Answers

what is exception and how many types of exception

1 Answers Active Brains,

In how many ways we can create a logical file?`

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

what is open data base command

1 Answers Active Brains, Cognizant, CSC, CTS,

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

5 Answers Accenture,

There are six records in a file and we are going to update that records and used commit operation when it complete the update but suppose when it updating the third record,a error occured and operation failed.Is previously two records will be update or whole operation will be rollback? Please confirm it.

2 Answers

What is FORMAT keyword and its use?

0 Answers

Why journalling is compulsory before commitment control?

1 Answers

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

3 Answers Four soft,

For more DB400 Interview Questions Click Here