AS/400 activation group and triggers

620 pts.
Tags:
AS/400
AS/400 triggers
Interview questions- please help me guys.
  1. I have two jobs and these jobs are accessing two different files. What is the default activation group (or activation group) is taken in these jobs? I have no idea about triggered programs, please help me.
  2. I have one triggered file and too many programs (update,delete and read) using this file. How do I find which programs are performed read, delete and update operation on this file? (is it DSPFD command or some other command)
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Splat
    The default activation group is just that, the default activation group.  From what I know it has no name.

    Try DSPPGMREF to identify objects and how they are used.
    12,915 pointsBadges:
    report
  • bvining
    It is undoubtedly too late to help with your interview questions, but for future readers:

    1. This question seems to be missing "something". All jobs do provide a default activation group (actually two) but the determination of what activation group will be used is not a job attribute, rather it's a program attribute. So asking "What is the default activation group taken in these jobs" strikes me as a trick question requiring you to ask more questions (like what program are we talking about).

    2. The trigger program associated with a file is passed several pieces of information. This information includes the physical file name, library, and member. It also provides the type of trigger event -- insert, update, delete, read. It does not provide the name of the application program performing the action BUT, as the trigger program runs inline to the action, the trigger program can use a variety of ways to determine the program name (I generally use the call stack but others take other approaches). This information -- file, event, program name -- can then be logged to a file for later examination. This log will tell you all programs that perform read, update, or delete operations on the file. There are other ways to get some of this type of information but as the question specifically mentions triggered files I'm reading that as a context within which to answer the question (that is, use the trigger program). I will point out that a static approach, such as DSPPGMREF, may not give a complete answer (overrides, prepared SQL statements, etc may/will not be "caught").

    Bruce Vining
    7,070 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: