Cloudscape System Tables
Page 11 of 17

SYSJDBCTYPEINFO

Used internally for the JDBC DatabaseMetaData methods. One row per type is built into the system. (See JDBC Database Access with Java, Hamilton, Cattell & Fisher, p. 209, for column descriptions.) The column-naming style differs from that of other system tables to conform to the JDBC DatabaseMetaData ResultSet column names.

Column Name

Type

Length

Nullable

TYPE_NAME

VARCHAR

128

false

DATA_TYPE

SMALLINT

2

false

PRECISION

INT

4

false

LITERAL_PREFIX

VARCHAR

10

true

LITERAL_SUFFIX

VARCHAR

10

true

CREATE_PARAMS

VARCHAR

10

true

NULLABLE

INT

4

false

CASE_SENSITIVE

BOOLEAN

1

false

SEARCHABLE

INT

4

false

UNSIGNED_ATTRIBUTE

BOOLEAN

1

false

FIXED_PREC_SCALE

BOOLEAN

1

false

AUTO_INCREMENT

BOOLEAN

1

false

LOCAL_TYPE_NAME

VARCHAR

128

false

MINIMUM_SCALE

SMALLINT

2

false

MAXIMUM_SCALE

SMALLINT

2

false

SQL_DATA_TYPE

INT

4

true

SQL_DATETIME_SUB

INT

4

true

NUM_PREC_RADIX

INT

4

false