<<<<<<< HEAD Add Field Triggers (ADDFLDTRG) ======= Add Alert (ADDCCALR) >>>>>>> bf4407dbacde8ffd1f4ff8c70c945e5db0feb2b8

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.

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 utilize 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.

Add Field Triggers (ADDFLDTRG)

Type choices, press Enter.

Field identifier . . . . . . . . CREDITCARD

Screen Example: ADDFLDTRG Command

Enter the Field identifier to recreate the triggers for.