DB2 Universal Database for iSeries SQL Reference

SQLUDTS

The SQLUDTS view contains one row for every distinct type. The following table describes the columns in the view:

Table 148. 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.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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]