Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Statements : CREATE GROUP
 

CREATE GROUP

Creates a group for the specified table in a multi-tenant database. A multi-tenant group allows multiple tenants to map to the same table partition for a multi-tenant table and therefore share the same data for that table. All data within the table partition is shared by the multiple tenants that are part of the group.
You can create multiple groups for the same table. The areas specified in the command prompt must be pre-existing as valid Type II areas in the database.

Syntax

CREATE GROUP group_name
FOR TABLE table_name TABLE AREA area_name_1
   [ INDEX AREA area_name_2]
  [ LOB AREA area_name_3]
   [ PRO_DESCRIPTION value]

Parameters

group_name
Specifies the name of the group for the multi-tenant table. The group name must be unique across the database.
table_name
Specifies the table name. The name of a referenced table must be a valid multi-tenant table. The table name can be qualified by an owner (schema) name.
TABLE AREA area_name
Is used for database space allocation for the table, during the CREATE GROUP statement execution. The TABLE AREA must be specified.
INDEX AREA index_area_name
Is used for database space allocation for the index, during the CREATE GROUP statement execution. The INDEX AREA specification is optional. The name of the storage area must be specified within double quotes.
If the storage area for an index is omitted in the syntax, the TABLE AREA acts as its default area.
LOB AREAlob_area_name
Is used for database space allocation for LOB, during the CREATE GROUP statement execution.The LOB AREA specification is optional. The name of the storage area must be specified within double quotes.
If the storage area for a LOB is omitted in the syntax, the TABLE AREA acts as its default area.
PRO_DESCRIPTION value
Allows you to enter the ABL description. The value attribute is an arbitrary character string.
FOR TABLE
Specifies the name of the table for which the group is defined.

Example

The following example shows how to create a group for a table and allocate partition space for the table, index, and LOB:
CREATE GROUP carz_second FOR TABLE pub.customer
       [ TABLE AREA "CUSTTABAREA" ]
       [ INDEX AREA "CUSTIDAREA" ]
       [ LOB AREA "CUSTTLOBAREA" ]
   [ PRO_DESCRIPTION "Second Group for CARZ" ]
* Authorization
* Related Statement