DMSII GROUP OCCURS
The following is an excerpt from a DMSII DASDL that shows a GROUP item that has an OCCURS clause.
SALES DATA SET
When this SALES data set is cloned into the relational database, it is mapped into the following tables:
Table 1 (primary table)
This table is named the same as the SALES DMSII data set, and it contains the key item and the data items that do not have OCCURS clauses. Because the GROUP item has an OCCURS clause, none of the GROUP items are included in this table. Assuming there are five records in the DMSII data set, there are also five rows in this relational database table.
sales (table name)
Table 2 (secondary table)
This table is named: datasetname + GROUP_OCCURS_name
Assuming there are five records in the DMSII data set, there are 25 records in this relational database table. The main difference here is the addition of an index to denote the occurrence number of the item.
sales_sales_history (table name)
product_code index1 total_units_sold yearly_sales_amount