SQLUDTS

The SQLUDTS view contains one row for every distinct type.

The following table describes the columns in the view:

Table 1. SQLUDTS 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.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
Start of changejava.sql.SQLXMLEnd of change
Start of changeXMLEnd of change
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
Start of change2009End of change
Start of changeXMLEnd of change
REMARKS Start of changeVARGRAPHIC(2000) CCSID 1200

Nullable

End of change
A character string supplied with the COMMENT statement.

Contains the null value if there is no comment.