IBM i Database Trigger Support › CA 2E Model Support › Editing Trigger Functions

Editing Trigger Functions

Once you create a Trigger Function, you can edit it using the Action Diagram Editor. From the EDIT FILE DETAILS panel, you can access a new EDIT FILE TRIGGER DETAILS panel to link Trigger Functions to a specific trigger for the owning file. This cross-reference link information is held in a CA 2E model file called YFILTRGRFP (MDL File Triggers) in an internal model-level format.

Press F18 from Edit File Details screen to get Edit File Trigger Details screen. Use this screen to link Trigger Functions to triggers based on the owning file.

EDIT FILE TRIGGER DETAILS

File name  . . . . . . . .: cat
Attribute  . . . . . . . .: REF
Source Library . . . . : UUA1SAMPLE
Distributed  . . . . . : N
Assimilated physical . . .:

D=Delete  F=Action Diagram
?        Time       Event     Cmt         Seq     Function
          A/B      D/I/R/U    Ctl 
                              Y/N
_          A          D        N           1      Trg fun - after, del________   
_          A          I        N           1      Trg fun 2 - after ins_______
_          _          _        _           __      ___________________________
_          _          _        _           __      ___________________________
_          _          _        _           __      ___________________________
_          _          _        _           __      ___________________________
_          _          _        _           __      ___________________________
_          _          _        _           __      ___________________________
_          _          _        _           __      ___________________________


 F3=Exit   F4=Prompt   F5=Refresh

Within the Display Model Usages screen, any trigger references specified in the model (that is, any Trigger Functions are linked to a trigger on the file over which they were created from the EDIT FILE TRIGGER DETAILS screen) are displayed with reason *TRGREF.

Gen Objs :     1         Display Model Usages               Model:  <name>

Total  . :     2                                            Level :  001
Object . :  Trg fun - after, del        Owner .: cat
Type . . :  FUN     Attribute . . :  RPG       Exclude system objs . *YES
Scope  . .  *NEXT___    Filter . .  *ANY___    Current Objects only . *YES
Object . . __________________________   Type . .____      Reason . .  *FIRST_

2=Edit    3=Copy    4=Delete object   5=Display   8=Details   10=Action diagram
13=Parms  14=GEN batch                15=GEN interactive      16=Y2CALL


Opt  Object                Typ Atr Owner                    Lvl Reason
__   cat                   FIL REF                          001 *TRGREF
__   Trg                   FUN RPG cat                      000 *OBJECT








F3=Exit   F5=Refresh   F9=Command line   F12=Previous          F15=Top level
F16=Build model list   F21=Print list    F22=File locks        F23=More options