CREATE 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)
CREATE DATABASE	YES	YES	NO

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

To learn about using SQL keywords in CA Dataquery, see the CA Dataquery User Guide.

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

Following is the syntax diagram for the CREATE DATABASE statement:

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

►►── CREATE DATABASE database-name DATACOM ────────────────────►
►─── DATACOM_ID nnnnn ─────────────────────────────────────────►
►─┬────────────────────────────────────────────────────┬───────►◄
  ├─ DATACOM_DD_NAME dd-occurrence-name ───────────────┤
  ├─ DYNAMIC_EXTEND ─┬─ NO ────────┬───────────────────┤
  │                  ├─ YES────────┤                   │
  │                  ├─TRACKS ─────┤                   │
  │                  └─CYLINDERS───┘                   │
  ├─ DYN_EXT_SIZE nnn ─────────────────────────────────┤
  └─ DL1T_CONSTRAINT ─┬─ NO ──┬────────────────────────┘
                      └─ YES──┘

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.