SQL Statements › ALTER AREA › Description

Description

area-name

Specify the name of the data area you want to alter. The area-name must identify an area described in the CA Datacom Datadictionary, but not a CA Datacom Datadictionary table.

DATACOM

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

BLOCK_SIZE nnnnn

Specify a valid block size. The size is a value greater than or equal to the length of the largest table stored in the data area.

DYNAMIC_EXTEND

Specify NO, YES, TRACKS, or CYLINDERS. The default is NO.

DYN_EXT_SIZE nnn

Specify a valid dynamic extension size.

SLACK nnnn

Specify a valid value for SLACK.

SPACE_MANAGEMENT

Specify BASIC, NONE, WRAP, CLUSTER, BASIC_BI, or WRAP_BI.

Note: BASIC_BI and WRAP_BI specifies “with Block Index” for BASIC and WRAP.

For more information about space management options, see your Database Administrator or the CA Datacom/DB Database and System Administration Guide.