trig_a_iu_enum_item_check()

A constraint trigger function to provide foreign key like validation of columns which reference syst_enum_items.

Trigger Function Details:

• Supported Timing: AFTER

• Supported Operations: INSERT, UPDATE

Parameters

• tg_argv[0] :: Required? True; Default: ( No Default )

  The name of the enumeration to validate against.

  This value will be the ms_syst_data.syst_enums.internal_name value which identified the enumeration.

• tg_argv[1] :: Required? True; Default: ( No Default )

  The name of the foreign key column in the host table which references ms_syst_data.syst_enum_items records.

General Usage

This relationship requires the additional check that only values from the desired enumeration are used in assigning to records.