The SQLUDTS view contains one row for every distinct type. The
following table describes the columns in the view:
Column Name
| Data Type
| Description
|
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.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
|
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
- 1
- CHARACTER
- -2
- CHARACTER FOR BIT DATA
- 12
- VARCHAR
- -3
- VARCHAR FOR BIT DATA
- 2005
- CLOB
- 1
- GRAPHIC
- 12
- VARGRAPHIC
- 1111
- DBCLOB
- -2
- BINARY
- -3
- VARBINARY
- 2004
- BLOB
- 91
- DATE
- 92
- TIME
- 93
- TIMESTAMP
- 70
- DATALINK
- 1111
- ROWID
|
REMARKS
| VARCHAR(2000)
Nullable
| A character string supplied with the COMMENT statement.
Contains the null value if there is no comment.
|
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.