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
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 |
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 to restrict upon adding the data for field reference file in DB400
Which keyword is used both in subfile and subfile control record format of a DSPF?
How to update physical file using logical file with example?
When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?
There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.
how to eliminate the level check error
what is open data path? and what is the diff b/w access path and open data path?
What is the interactive job? What is the batch job?
Why journalling is compulsory before commitment control?
what is the intractive job? what is the batch job ? how to change the batch job to interactive job?
How many libraries can be there in a library list?
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?