Remove Field Triggers (RMVFLDTRG)

The Remove Field Triggers (RMVFLDTRG) command will remove any SQL triggers that were created by Powertech Encryption on the database file for the specified Field Identifier (when it was activated with ACTFLDENC).

RMVFLDTRG is useful for temporarily removing the triggers when special maintenance operations need to be performed on the database file, such as adding a new field to the file through a change management tool.

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

NOTE:
  • You should not allow other users or applications to access the database file while the SQL Triggers are removed. Otherwise, field values may be added/updated in the file in unencrypted format.
  • RMVFLDTRG only removes the SQL Triggers from the database file. Any field values, which existed before RMVFLDTRG was executed, will remain encrypted. The field entry will keep an *ACTIVE status in the Field Encryption Registry.
  • If you want to decrypt the existing field values and remove the SQL triggers, then the DCTFLDENC (Deactive Field Encryption) command should be used.
  • Use the ADDFLDTRG command to recreate the SQL Triggers on the database file.

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

NOTE: Use the ADDFLDTRG command to recreate the SQL Triggers on the database file.

How to Get There

From the Field Triggers Menu, choose option 1, Remove Field Triggers. Or, execute the command RMVFLDTRG.

Options

Field identifier (FLDID)

Enter the Field identifier to remove the SQL triggers for.