Flattening OCCURS Clause for Three-Bit Numeric Flags
MISER systems store certain flags as arrays of single-digit numbers, where each number is used to hold three Boolean values. The DATABridge Client can be directed to map these items as a series of Booleans data items (bit in SQL Server). To do this, set the DIOPT_Flatten_Occurs bit (1) and the DIOPT_Clone_as_Tribit bit (16) in the di_options column of the corresponding DMS_ITEMS record.
An example for the item L‑LOCK‑FLAG in the data set LOAN follows:
update DMS_ITEMS set di_options=17
In the above example, if the L-LOCK_FLAG has an OCCURS 20 TIMES clause, 60 items of type bit named l_lock_flag_01 to l_lock_flag_60 are created.
These items can also be flattened to a secondary table by setting the bit DIOPT_FlatSecondary(4096) in the di_options column for the corresponding entry in the DMS_ITEMS table.