CDL statements
CDL statements are used to create, alter, and drop objects.
The -CDL command in a CDL file contains a CDL statement. Each CDL statement contains a command, parameters, and variables. This section provides a syntax diagram and description of each CDL statement.
Each CDL statement contains variables. The following table provides a list of the variables and their definitions. The variable definitions use the terms short identifier and long identifier as they are defined in the IBM documentation. A short identifier is 8 characters long. A long identifier is 128 characters long. The ALTER and BMC AMI Change Manager for Db2 products support delimited identifiers for the owners of Db2 objects and Db2 object names that use long identifiers.
Variable | Identifier type | Definition |
|---|---|---|
aliasName | Long | Names an alias |
aliasOwner | Short | Names the owner of an alias |
authorizationID | Short | Specifies an authorization ID that the operating system recognizes as valid |
bufferPoolName | NA | Names a buffer pool |
catalogName | Short | Names a catalog |
checkConstraintName | Short | Names a check constraint |
columnName | Long | Names a column in a table or view |
columnNameList | NA | List of columns for a trigger |
constant | NA | Specifies a value that is passed to a procedure The type and syntax of a constant is dependent on the procedure but will usually be a numeric or string value. |
constraintName | Short | Names a referential integrity constraint (foreign key definition) |
constraintText | NA | Specifies the check constraint text |
correlationName | NA | Names a correlation |
databaseName | Short | Names a database |
dataTypeName | NA | Names the data type of a table column |
dataTypeSchema | N/A | Names the schema type of a table column |
identifier | NA | Specifies the OLD_TABLE AS or NEW_TABLE AS identifier for a trigger |
indexName | Long | Names an index |
indexOwner | Short | Names the owner of an index |
locationID | NA | Designates a Db2 subsystem The ID can be 1 to 16 characters in length. |
number | NA | Specifies an integer |
partitionNumber | NA | Identifies a partition in a partitioned index space or table space When the value is 0, it identifies a nonpartitioned index space or table space. |
password | Short | Specifies a password that the operating system recognizes as valid |
procedureName | NA | Names an edit procedure, validation procedure, or field procedure for a table |
schema | NA | Names a collection of objects |
schemaList | NA | Names a list of a collection of objects |
sequenceName | NA | Names a sequence |
statementNumber | NA | Specifies a six-digit statement number in a CDL input file Leading zeros are required, and the statement number must occupy columns 7-12 of the line of a command. |
storageGroupName | Short | Names a storage group |
subselect | NA | Names the SQL subselect statement for a view |
subsystemID | NA | Names a Db2 subsystem The ID can be 1 to 4 characters in length. |
synonymName | Long | Names a synonym |
synonymOwner | Short | Names the owner of a synonym |
tableName | Long | Names a table |
tableOwner | Short | Names the owner of a table |
tableSpaceName | Short | Names a table space |
triggerName | Long | Names a trigger |
triggerOwner | Short | Names the owner of a trigger |
triggerText | NA | Specifies the trigger text |
uniqueConstraintName | NA | Names a unique constraint |
viewName | Long | Names a view |
viewOwner | Short | Names the owner of a view |
volumeSerialNumber | NA | Names a volume The ID can be 1 to 6 characters in length. |
This section contains the following topics:
Related topic