| TYPE_CAT |
VARCHAR(128) |
Relational database name |
| TYPE_SCHEM |
VARCHAR(128) |
Name of the schema containing the
user-defined type. |
| TYPE_NAME |
VARCHAR(128) |
Name of the user-defined type. |
| CLASS_NAME |
VARCHAR(20) |
Java™ class
name of the user-defined type. - java.math.BigInteger
- BIGINT
- java.lang.Integer
- INTEGER
- java.lang.Short
- SMALLINT
- java.math.BigDecimal
- DECIMAL
- java.sql.BigDecimal
- NUMERIC
- java.lang.Double
- DOUBLE PRECISION
- java.lang.Float
- REAL
- java.math.BigDecimal
- DECFLOAT
- java.lang.String
- CHARACTER
- byte[]
- CHARACTER FOR BIT DATA
- java.lang.String
- VARCHAR
- byte[]
- VARCHAR FOR BIT DATA
- java.sql.Clob
- CLOB
- java.lang.String
- GRAPHIC
- java.lang.String
- VARGRAPHIC
- java.sql.Clob
- DBCLOB
- byte[]
- BINARY
- byte[]
- VARBINARY
- java.sql.Blob
- BLOB
- java.sql.Date
- DATE
- java.sql.Time
- TIME
- java.sql.Timestamp
- TIMESTAMP
- java.net.URL
- DATALINK
- byte[]
- ROWID
java.sql.SQLXML
XML
|
| DATA_TYPE |
SMALLINT |
Reserved. Contains 2001. |
| BASE_TYPE |
SMALLINT |
The source data type of the user-defined
data type: - –5
- BIGINT
- 4
- INTEGER
- 5
- SMALLINT
- 3
- DECIMAL
- 2
- NUMERIC
- 8
- DOUBLE PRECISION
- 7
- REAL
- 1111
- DECFLOAT
- 1
- CHARACTER
- –2
- CHARACTER FOR BIT DATA
- 12
- VARCHAR
- –3
- VARCHAR FOR BIT DATA
- 2005
- CLOB
- 1
- GRAPHIC
- 12
- VARGRAPHIC
- 2005
- DBCLOB
- –2
- BINARY
- –3
- VARBINARY
- 2004
- BLOB
- 91
- DATE
- 92
- TIME
- 93
- TIMESTAMP
- 70
- DATALINK
- 1111
- ROWID
2009
XML
|
| REMARKS |
VARGRAPHIC(2000) CCSID
1200Nullable
 |
A character string supplied with
the COMMENT statement. Contains the null value if there is no comment.
|