ALTER DATABASE

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 DATABASE	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 DATABASE statement:

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

►►── ALTER DATABASE database-name DATACOM ────────────────────►
►─┬───────────────────────────────────────────────────┬───────►◄
  ├─ DYNAMIC_EXTEND ─┬─ NO ────────┬──────────────────┤
  │                  ├─ YES────────┤                  │
  │                  ├─TRACKS ─────┤                  │
  │                  └─CYLINDERS───┘                  │
  └─ DYN_EXT_SIZE nnn ────────────────────────────────┘