Handling DMSII GROUPs
A GROUP is a DMSII construct that allows the data items that belong to the group to be referenced at one time (for example, as one item). The concept of GROUP does not exist in a relational database. Therefore, if the DMSII database you replicate has one or more GROUPs, the DATABridge Client ignores the GROUP name and instead treats each GROUP item as a data item. All items in a DMSII GROUP share the same item number.
Following is an example of the DMSII GROUP item in the data set called ADDRESS. This GROUP item consists of the data item CITY and the data item STATE.
DMSII DASDL Showing GROUP
The following is an excerpt from a DMSII DASDL that shows how a GROUP item is defined. With the GROUP item, you can access both city and state with one reference.
ADDRESS DATA SET
The next example shows how the same DMSII GROUP item is mapped to a relational database.
Relational Database Table
The following example is for Microsoft SQL Server.
The table name is the lowercase form of the DMSII data set name. The GROUP item CITY-STATE is ignored. The data items in that group are included in the relational database table as if they were ordinary DMSII data items.
address (table name)
street apartment city state country zipcode postfix
May St. 3 Paris OH USA 15010 2146
If there are duplicate names among members of various groups within a data set, the DATABridge Client resolves the conflict by appending a digit to the column name to make it unique. Older releases of the DATABridge Client achieved the same thing by appending a suffix of _g#.