The name of a column of the table. Do not use the same name for more than one column in this table.
If you specify SQLMODE=ANSI or SQLMODE=FIPS in the Preprocessor options, the column name can be 1 to 18 characters in length.
If you specify SQLMODE=DATACOM for extended mode in the Preprocessor options, the column name can be 1 to 32 characters in length.
The number of columns you can define for a single table is limited only by the maximum size of the physical record. The sum of the byte counts of the columns must not be less than 1 or greater than 32720.
If you use the UNIQUE (column-list) constraint in a table constraint definition (see Table Constraint Definition), you must separate the last column definition from the UNIQUE (column-list) constraint with a comma.
If you specify a ref-col-name in the column constraint definition (see Column Constraint Definition), the data type, length, and scale of the column-name specified here in the column definition must be identical to those of the ref-col-name.
The first column you name in the CREATE TABLE statement becomes the CA Datacom/DB Master and Native Key for the table, except when a Primary or Unique Key has been defined. The Native Key is either the first column, if no Primary or Unique Key is specified, or it is the last Primary or Unique Key specified. If the Native Key is being defined on different column(s), either omit all Primary or Unique Keys on the CREATE TABLE statement, to have the first column default to the Native Key, or specify just the Primary Key, if it is to also be the Native Key, then add the Unique Keys later using the ALTER TABLE statement.
Note: There is no facility to assign the Native Key to column(s) that are not the first or last Primary or Unique Key. In this case, use CA Datacom Datadictionary to change the Native Key.
CA Datacom Datadictionary automatically generates this KEY entity-occurrence, which has the same name as the column.
Note: The DUPE-MASTER-KEY and CHNG-MASTER-KEY attributes of the TABLE entity-occurrence are set to Y, indicating that the value of the Master Key can be duplicated and/or changed. The 5-character CA Datacom/DB name of the key is SQnnn, where nnn is a sequential number unique to each database.
See Data Types.
Note: If NOT NULL WITH DEFAULT is specified as a constraint with DATE, TIME, or TIMESTAMP, the default value is the current date, current time, or current timestamp.
You have the option to specify UNSIGNED following the data type.
Used to specify a default. If DEFAULT is specified, you cannot use a column constraint of WITH DEFAULT.
Specifies a literal as the default. The literal you specify must be consistent with the data type of the column. A user-supplied DEFAULT literal can be up to 20 bytes long, or the length of the column involved, whichever is shorter. A default value may be specified for a character column where the column is greater than 20 bytes long, but the default literal itself is limited to 20 bytes, with the remaining bytes padded with blanks by the system.
Specifies NULL as the default. If NULL is specified, you cannot use a column constraint of NOT NULL.
See the column constraint definition in the following.
Specifies the current authorization ID as the default.
This CA Datacom/DB extension specifies the accessor ID of the currently signed-on user as the default.
|
Copyright © 2014 CA.
All rights reserved.
|
|