The BEGIN GROUP and END GROUP commands simplify the specification of Datastores containing multiple Tables, Segments or Records by allowing the Descriptions to be grouped together and named. The named group can then be referenced in subsequent DATASTORE commands. This also simplifies the PROCESS INTO command because only a single Datastore Alias needs to be referenced.
Syntax
BEGIN GROUP <group_name>
DESCRIPTION <description_type> <file_name> AS <description_alias;
DESCRIPTION <description_type> <file_name> AS <description_alias;
DESCRIPTION <description_type> <file_name> AS <description_alias;
END GROUP;
Keyword and Parameter Descriptions
| Keyword | Description |
|---|---|
| <group_name> | The "name" assigned to the group of Descriptions. |
Example
Specify a group named HR_DB2 containing the z/OS DB2 EMP and DEP tables to be referenced by the target Datastore.
BEGIN GROUP HR_DB2
DESCRIPTION DB2SQL DD:DB2DDL(EMP) AS I_EMP;
DESCRIPTION DB2SQL DD:DB2DDL(DEPT) AS I_DEPT;
END GROUP;
DATASTORE RDBMS
OF RELATIONAL
AS TARGET
DESCRIBED BY GROUP HR_DB2;
PROCESS INTO TARGET