Columns View

Column

Data Type

N

Description

RECORD_NUMBER

integer

n

unique identifier for this record of metadata

TABLE_CATALOG

identifier

n

table catalog

TABLE_SCHEMA

identifier

n

table schema

TABLE_NAME

identifier

n

table name

COLUMN_NAME

identifier

n

column name

ORDINAL_POSITION

integer

n

ordinal position inside the containing  table.

COLUMN_DEFAULT

long_alpha

y

default option in character representation.

IS_NULLABLE

yes_no

n

Y if Null is possible, N if not possible.

DATA_TYPE_NUMBER

short

n

data type (in integer form)

DATA_TYPE

enumeration

n

data type (in text form)

CHARACTER_MAXIMUM_LENGTH

long

n

physical length of data in characters.

CHARACTER_OCTET_LENGTH

long

n

physical length of data in bytes.

NUMERIC_PRECISION

long

n

precision of the data.

NUMERIC_PRECISION_RADIX

short

n

Radix of the precision.  Radix is 2 for floating point data
and 10 for integral data.

NUMERIC_SCALE

short

n

scale of the data.

DATETIME_PRECISION

short

n

precision of the timestamp

SHORT_NAME

char(2)

y

Adabas short name

MU_POS

short

y

Position of the column within an Adabas MU field.

COLUMN_LEVEL

short

n

0 = non MU/PE column, 1 = top level MU or PE, 2 = MU within PE

COLUMN_TYPE

enumeration

n

always returns "Ordinary"

CHARACTER_SET_CATALOG

identifier

n

character set of the catalog  (currently not used)

CHARACTER_SET_SCHEMA

identifier

n

character set of the schema  (currently not used)

CHARACTER_SET_NAME

identifier

n

character set of the name  (currently not used)

COLLATION_CATALOG

identifier

n

collation of the catalog  (currently not used)

COLLATION_SCHEMA

identifier

n

collation of the schema  (currently not used)

COLLATION_NAME

identifier

n

collation of the name  (currently not used)

DOMAIN_CATALOG

identifier

n

domain name of the catalog  (currently not used)

DOMAIN_SCHEMA

identifier

n

domain name of the schema  (currently not used)

DOMAIN_NAME

identifier

n

domain name  (currently not used)