SQL Statements › CREATE AREA › Description

Description

area-name

Specify a valid SQL Identifier for the name of the area you want to create.

DATACOM

Indicates that all following attributes are specific to CA Datacom/DB. Specify the word DATACOM.

BLOCK_SIZE nnnnn

Defines the area’s physical block size in bytes. The block size is a value greater than or equal to the length of the largest table stored in the data area. Valid values are 512-32760.

IN DATABASE database-name

For database-name, specify an existing database SQL name.

DATACOM_NAME xxx

Specify for xxx a valid 3-character CA Datacom/DB short name for the area. The first character must be alphabetic, the second and third characters can be alphanumeric. Do not specify a name with the last two characters being XX. For valid values, see the CA Datacom Datadictionary Attribute Reference Guide.

DATACOM_DD_NAME dd-occurrence-name

Specify for the dd-occurrence-name a 1-32 character CA Datacom Datadictionary occurrence name.

DYNAMIC_EXTEND

Allows a user to have CA Datacom/DB attempt to extend the data area dynamically. Specify NO, YES, TRACKS, or CYLINDERS.

DYN_EXT_SIZE nnn

Specify the number of tracks or cylinders by which CA Datacom/DB can extend the Data Area. The valid range is 0-65535.

SLACK nnnn

The number of bytes to be reserved in each block of an area for the expansion of compressed physical records at the time a new row is inserted. This attribute provides space for compressed records that are prone to expand over time due to updates. The valid range is 0-32760, but must be less than the block size.

SPACE_MANAGEMENT

The CA Datacom/DB space management option.

Valid values are as follows:

NONE

no space reclamation

BASIC

space reclamation

WRAP

wraparound

CLUSTER

cluster

BASIC_BI

basic with block index

WRAP_BI

wraparound with block index

For more information about any of the attributes, see your Database Administrator or the CA Datacom Datadictionary Attribute Reference Guide.