Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

pls anyone explain about compile time array,pre run time array run time array

4 Answers  


Suppose if a physical file is having 1000 records, but i deleted 500 records from it. Here the concern is can the size of the file changes or it remains the same... kindly help me out with thorough xplanation.... Thanks in-advance...

6 Answers   ABC, TCS,


Define interactive jobs and batch jobs

6 Answers  


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

7 Answers  


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,


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

0 Answers  


YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE THROUGH CL?

4 Answers  


In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.

0 Answers   Nous,


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

2 Answers   Cap Gemini,


Last statement of any RPG pgm is LR?

5 Answers  


What is the interactive job? What is the batch job? How to change the batch job to interactive job?

0 Answers  


How to read a pf in reverse(from last record to first) using cl?

0 Answers  


Categories