Home > AS/400 Tips > iSeries administrator tips > Advanced trigger applications -- part 2

	iSeries 400 Tips:	EMAIL THIS

	TIPS & NEWSLETTERS TOPICS

	ISERIES ADMINISTRATOR TIPS Advanced trigger applications -- part 2 Ron Turull 04.10.2006 Rating: -5.00- (out of 5) Digg This!     StumbleUpon     Del.icio.us    [TABLE]A trigger program is just like any other program with a few restrictions on what it can do. In part 1 of this series, we discussed one of these restrictions: the trigger program's parameter list. Since the system will be calling the trigger program, it's parameter list must be strictly coded. Once a trigger program has been successful called, it can do almost anything a non-trigger program can. In this installment, we'll discuss in detail the other things trigger programs must not and/or should not do. [TABLE]			[IMAGE]

Reviewing the trigger categories

When discussing the restrictions placed on trigger programs, it is important to remember the six types of triggers. The differences among them have to do with why and when they are called. Three record I/O events cause triggers to be called -- deletion, insertion, and update. In addition, a trigger can be configured so it is called either before or after the database carries out the I/O event. This produces the following six possible combinations:

1. Before delete

2. After delete

3. Before insert

4. After insert

5. Before update

6. After update

Also recall that the same trigger program can be attached to multiple files and/or to the same file multiple times as different types of triggers.

Four issues regarding trigger inter-operability with i5/OS functions

Some i5/OS (OS/400) commands affecting physical files may not work as designed when triggers are involved. Here are a few of the more common situations:

1. When an attempt is made to clear -- either directly or indirectly -- a member of a physical file that has a delete trigger attached to it, the operation will fail with escape message CPF3157. An e

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT iSeries administrator tips Translating Linux for IBM i admins: Using GUI to make it easy Translating Linux for IBM i admins: Working with jobs and networking OpenOffice: What to know before making the transition from Microsoft Office OpenOffice: An enterprise open source solution Database performance comparisons on IBM i Translating Linux for IBM i admins: User profile commands Modern System i reports using Client Access Tips for installing Lotus Domino server on a System i partition The iSeries Blog has a new home on IT Knowledge Exchange Virtualization for IBM i: Backups

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

xample of a direct clear-member operation is the Clear Physical File Member (CLRPFM) command. An example of an indirect clear-member operation is the Copy File (CPYF) command when the *REPLACE option is specified for the MBROPT keyword/parameter.

1. A file's trigger information is not copied to the new file when executing a CPYF command with CRTFILE(*YES). That is, the resulting newly-created file will not have any trigger programs attached to it.

2. Delete triggers are not called when the associated file is deleted (e.g., using the DLTF command).

3. To duplicate a file and its associated trigger programs to another library, and have the duplicated trigger programs associated with the duplicated file, first duplicate all the trigger programs, and then duplicate the file to the same library as the duplicated trigger programs. The system will automatically perform the re-association. Note: The duplicated objects should be given the same names as the original objects.

Operations that are invalid or not recommended in trigger programs

The following operations are not valid in a trigger program:

In addition, IBM recommends not using the following commands in a trigger program. The commands can be used, but caution should be exercised.

• Start Commitment Control (STRCMTCTL)
  
  
• Reclaim Spool Storage (RCLSPLSTG)
  
  
• Reclaim Resources (RCLRSC)
  
  
• Change System Library List (CHGSYSLIBL)
  
  
• Delete, Restore, or Save Licensed Program (DLTLICPGM, RSTLICPGM, or SAVLICPGM)
  
  
• Save Library (SAVLIB) command with *YES specified for the SAVACT keyword/parameter.
  
  
• Any command accessing a diskette or tape drive (because of long access times and the possibility that the wrong volume -- or no volume at all -- will be loaded).
  
  
• Any migration commands.
  
  
• Starting debug (a security exposure).
  
  
• Any commands related to remote job entry (RJE).
  
  
• Invoking/calling a program or CL command that results in an interactive entry screen (could reach lock resource limit).

  Looking ahead

  In the next installment, we'll start our tour of three unique trigger programs. Stay tuned.

  -----------------------------------
  About the author: Ron Turull is editor of Inside Version 5. He has more than 20 years' experience programming for and managing AS/400-iSeries systems.

  
  

  Rate this Tip To rate tips, you must be a member of Search400.com. Register now to start rating these tips. Log in if you are already a member. Submit a Tip DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.