A row of SYSTEM.ORDERKEY represents a column that is a sort key in a linked constraint. This is a column in the referencing table. This information is for documentation and is not used in internal processing.
View SYSCA.ORDERKEY is defined on SYSTEM.ORDERKEY.
Note: For more information, see SYSCA Objects.
|
Column name |
Column description |
Data type |
Null specifi- cation |
|---|---|---|---|
|
SCHEMA |
Schema name of the constraint (that is, of the referencing table). |
CHAR(18) |
NOT NULL |
|
CONSTRAINT |
Constraint name. |
CHAR(18) |
NOT NULL |
|
SEQUENCE |
Order key column sequence number. |
SMALLINT |
NOT NULL |
|
NUMBER |
Column number of the sort column in the referencing table. |
SMALLINT |
NOT NULL |
|
COLUMN |
Column name of the sort column in the referencing table. |
CHAR(32) |
NOT NULL |
|
SORTORDER |
Sort order:
|
CHAR(1) |
NOT NULL |
|
FILLER |
Reserved for future use. |
BINARY(39) |
NOT NULL |
|
Copyright © 2014 CA.
All rights reserved.
|
|