SQL Statements › CREATE DATABASE › Description

Description

database-name

Specify a valid SQL Identifier for the name of the database you want to create.

DATACOM

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

DATACOM_ID nnnnn

Specify a valid database identifier (DBID). The DBID is stored in the CA Datacom/DB Directory (CXX). Valid values for nnnnn are 5-digit numbers from 1 through 5000. There is no default value. An error is generated if you specify an invalid DBID value. For more information, see the CA Datacom Datadictionary Attribute Reference Guide.

Note: You cannot change a database DBID using the ALTER DATABASE statement. To change a DBID, use the DROP DATABASE statement then recreate the database using CREATE DATABASE with the preferred DBID. See DROP DATABASE and CREATE DATABASE.

DATACOM_DD_NAME dd-occurrence-name

Specify for the dd-occurrence-name a 1-32 character CA Datacom Datadictionary occurrence name.

DYNAMIC_EXTEND

Allows a user to have CA Datacom/DB attempt to extend the index area dynamically. Specify NO, YES, TRACKS, or CYLINDERS.

DYN_EXT_SIZE nnn

Specify a valid dynamic extension size. For valid values, see the CA Datacom Datadictionary Attribute Reference Guide.

DL1T_CONSTRAINT

YES indicates the database is eligible for CA Datacom Transparency Option for DL/I integrity processing. Specify YES or NO.