Add Field Triggers (ADDFLDTRG)

The Add Field Triggers (ADDFLDTRG) command will recreate any SQL triggers that were removed with the RMVFLDTRG command.

ADDFLDTRG can only be used for *ACTIVE field entries which were configured in the Registry to use SQL triggers.

NOTE:
  • ADDFLDTRG only recreates the SQL Triggers on the database file.
  • Any field values, which existed before ADDFLDTRG was executed, will remain in their current form.
  • The field entry will keep an *ACTIVE status in the Field Encryption Registry.

The following users can use this command:

  • QSECOFR user profile (unless excluded in the Key Officer settings)
  • A user profile with *SECADM authority (unless excluded in the Key Officer settings)
  • A Key Officer who has a *YES specified for the "Maintain Field Enc. Registry" authority setting

This command requires that you have the following object authorities:

  • *USE authority for the CRVL002 *VLDL object which contains the Field Encryption Registry.
  • Alter authority for the database file specified on the field entry.

How to Get There

From the Field Triggers Menu, choose option 2.

Options

Field identifier (FLDID)

Enter the Field identifier to recreate the triggers for.