This table is used to define operators.
Column Description(s):
Column Name | Column Type | Description |
OPERATOR_ID |
INTEGER NOT NULL |
Unique table index. This is the primary key. |
OPERATOR |
CHAR(32) NOT NULL |
The operator. For example, "<" or ">=". |
OPERATORTYPE |
CHAR(1) NOT NULL DEFAULT '1' |
The operator type:- Simple operator (allows a single value) - Default
- Compound operator (range - continuous)
- Compound operator (set)
|
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031242420 |
OPERATOR_ID |
Primary Key |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_72 |
OPERATOR_ID |
ATTRVALUE |
OPERATOR_ID |
Cascade |
F_482 |
OPERATOR_ID |
OPERATRDSC |
OPERATOR_ID |
Cascade |
F_570 |
OPERATOR_ID |
PATTRVALUE |
OPERATOR_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.