If UNIQUE is specified, the created index enforces value uniqueness and provides an efficient means of both retrieving rows containing specific data values and of ordering the data. The index is rejected if the table contains non-unique values.
An optional identifier of the schema for the index and table. If specified for the index-name, it must be the same as the authorization ID of the table you have specified with the table-name. Use a period (.) to concatenate the authorization ID to the index name or table name (for example, auth-id.table-name).
The name for the index you are creating. The index-name you supply, including the implicit or explicit qualifier (authid), must not identify an index already described in CA Datacom Datadictionary.
Specify the name of the table to be indexed. Must be a table described in CA Datacom Datadictionary.
Specifies the name of a column or a list of columns. The column(s) must belong to the table you have specified with the table-name. If more than one column name is listed, each name must be different and separated by commas. The name of a column or a list of columns must be enclosed in parentheses.
Places the values of the column in ascending order. ASC is the default order.
Places the values of the column in descending order.
Specifies a five-character DATACOM NAME name (a KEY entity-occurrence in CA Datacom Datadictionary ) for the index. If you do not specify a DATACOM NAME name, CA Datacom Datadictionary generates a name for you. (This is not the CA Datacom Datadictionary entity-occurrence name.)
|
Copyright © 2014 CA.
All rights reserved.
|
|