This chart summarizes when you will be required to make the physical table, the index and the OAM operational after making a specific change.
Trigger functions are included in the chart because they might need to be recompiled more frequently than 'normal' functions. The table level trigger functions have a list of the columns in the table, in the correct order, including virtual columns. If anything like column type, length, order of columns, etc. changes, the trigger must be recompiled.
Trigger functions and normal functions may or may not require a recompile, depending on how the functions use the changed columns. This is indicated with 'O' for Optional.
Note: A trigger and a trigger function are not the same thing. A trigger is the definition of when a function will be called. It consists of trigger points, trigger conditions and the name of the trigger function. A trigger function is an RDML coded program that defines the action to be taken.
Refer to LANSA's technical support pages for more details.