Flattening OCCURS Clause for Items Cloned as Dates

The following script directs the define and redefine commands to map an item with an OCCURS clause as a series of columns, whose data type is a relational database date type, in the corresponding table. Furthermore, it specifies that the DMSII item, which is of type NUMBER(8), contains a date in the mm/dd/yyyy format.

Filename: script.user_layout.billing

update DMS_ITEMS set di_options=3, dms_subtype=23
where dms_item_name = 'BILLING-DATES' and dataset_name = 'BILLING'