DMSII OCCURS items and DATABridge

Technical Note PSBEL268
Created 21-Mar-2002

Applies To
DATABridge Client

OCCURS

Goal

DMSII OCCURS items and DATABridge

Cause

DMSII allows complex structures like multidimensional arrays caused by embedded repeated elements.  These are identified in the DASDL by the OCCURS x TIMES syntax.  Relational databases could have trouble with these structures which can be quite large.  So, by default, DATABridge Client breaks each occurring item into a separate secondary table.  However, some OCCURS structures could be a single level occurrence and therefore might easily be kept within the primary table.  

Fix

Use Client configuration option flatten_occurs = yes to prevent all secondary occurring tables.
To control the Flatten Occurs option one element at a time, add 1 to di_options in the DMS_ITEMS Client Control table, using script.user_layout.tablename.

For example, if the di_options = 0 of the occurring item, add the following command:

    update DMS_ITEMS set di_options = 1, where dms_item_name = 'NAME" and dataset_name = 'DSNAME'

If there is already a layout script command which sets this item's di_options = 2, for example because of date mapping, you would need to edit that command to di_options = 3.