CREATE AREA

In the following table, YES indicates a valid execution method for this statement.

This SQL statement can be executed in the following ways:	Through the CA Datacom Datadictionary Interactive SQL Service Facility (interactive)	In an application program prepared using a CA Datacom/DB SQL Preprocessor (embedded)	By using CA Dataquery (SQL & Batch Modes)
CREATE AREA	YES	YES	NO

For information about the access rights required to execute this statement, see the CA Datacom/DB Database and System Administration Guide.

If you are using CA Datacom/AD, you cannot use the CREATE AREA statement.

Following is the syntax diagram for the CREATE AREA statement:

Note: Use commas between the optional parameters, if needed, for example, DYNAMIC_EXTEND TRACKS, DYN_EXT_SIZE nnn.

►►── CREATE AREA area-name DATACOM ──────────────────────────────►
►─── BLOCK_SIZE nnnnn ─ IN DATABASE database-name ───────────────►
►─── DATACOM_NAME xxx──┬──────────────────────────────────────┬─►◄
                       ├─ DATACOM_DD_NAME dd-occurrence-name ─┤
                       ├─ DYNAMIC_EXTEND ─┬─ NO ────────┬─────┤
                       │                  ├─ YES ───────┤     │
                       │                  ├─ TRACKS ────┤     │
                       │                  └─ CYLINDERS ─┘     │
                       ├─ DYN_EXT_SIZE nnn ───────────────────┤
                       ├─ SLACK nnnn ─────────────────────────┤
                       └─ SPACE_MANAGEMENT ─┬─ BASIC ────┬────┘
                                            ├─ NONE ─────┤
                                            ├─ WRAP ─────┤
                                            ├─ CLUSTER ──┤
                                            ├─ BASIC_BI ─┤
                                            └─ WRAP_BI ──┘

Note: Prior to using any table(s) created in a new Database and Area, the data areas and index areas must be allocated and initialized, or the DBUTLTY function PREINIT must be used. For more information, see the CA Datacom/DB DBUTLTY Reference Guide.