This table contains a reference list of data types.
Column Name | Column Type | Column Description |
---|---|---|
BASETYPE | CHARACTER (100) NOT NULL |
The Java class used to hold values of this data type. |
CLASSNAME | CHARACTER (100) NOT NULL |
Class name of the data type. |
DEFAULTTYPE | INTEGER NOT NULL, DEFAULT 0 |
Reserved for IBM internal use. |
DISPLAYNAME | CHARACTER (80) NOT NULL |
The name to be used for this data type when displayed using a graphical interface. |
ORDERSEQ | INTEGER NULL |
Order sequence of the data types in GUI. |
REFID | INTEGER NOT NULL |
The internal reference number of the data type. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000116 | CLASSNAME | Unique Index |
SQL030416034939210 | REFID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_8 | REFID | ACATTR | DATATYPE | Cascade |