sec_tab_column_mask

Default: 0
Range: 0 – 16383

The parameter sec_tab_column_mask eliminates a set of user-defined external_columns from secondary tables without having to write extensive scripts to set active = 0 for the unwanted columns. To remove those columns, the Client removes the bits you specified in sec_tab_column_mask from the value represented in external_columns and uses the resulting value to determine which user columns to add to secondary tables during define and redefine commands.

This parameter is intended for adding the audit timestamp, the audit file number, or the audit block to primary tables without adding them to secondary tables. The default value of this parameter is 0, which indicates that no user columns should be removed from secondary tables.