ALTER 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)
ALTER AREA	YES	YES	NO

Note: YES indicates a valid execution method for this statement.

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

Following is the syntax diagram for the ALTER AREA statement:

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

►►── ALTER AREA area-name DATACOM ──────────────────────────────────►
►─┬───────────────────────────────────┬─────────────────────────────►◄
  ├─ BLOCK_SIZE nnnnn ────────────────┤
  ├─ DYNAMIC_EXTEND ─┬─ NO ────────┬──┤
  │                  ├─ YES ───────┤  │
  │                  ├─ TRACKS ────┤  │
  │                  └─ CYLINDERS ─┘  │
  ├─ DYN_EXT_SIZE nnn ────────────────┤
  ├─ SLACK nnnn ──────────────────────┤
  └─ SPACE_MANAGEMENT ─┬─ BASIC ────┬─┘
                       ├─ NONE ─────┤
                       ├─ WRAP ─────┤
                       ├─ CLUSTER ──┤
                       ├─ BASIC_BI ─┤
                       └─ WRAP_BI ──┘