Summary of Data Dictionary Tables

Summary of Data Dictionary Tables

Table name

Description

API_FUNCTION

translation of id to function or module name. See SYSTEM.API_FUNCTION.

AST_CODES

binary representation of the search condition of views in the database (for internal use). See SYSTEM.AST_CODES.

AST_SOURCES

textual representation of view definitions and tables and domains with check constraints. See SYSTEM.AST_SOURCES.

CHAR_SETS

character sets in the database. See SYSTEM.CHAR_SETS.

CHECK_CONSTRAINTS

check constraints defined for tables and domains. See SYSTEM.CHECK_CONSTRAINTS.

COLLATE_DEFS

collation definitions. See SYSTEM.COLLATE_DEFS

COLLATIONS

character collations in the database. See SYSTEM.COLLATIONS.

COLUMN_OBJECT_USE

columns that depend on other database objects. See SYSTEM.COLUMN_OBJECT_USE.

COLUMN_PRIVILEGES

instances of privileges granted on a column. See SYSTEM.COLUMN_PRIVILEGES.

COLUMNS

columns in tables or views. See SYSTEM.COLUMNS.

DATABANKS

databanks in the database. See SYSTEM.DATABANKS.

DOMAIN_CONSTRAINTS

constraints defined for domains. See SYSTEM.DOMAIN_CONSTRAINTS.

DOMAINS

domains in the database. See SYSTEM.DOMAINS.

EXEC_STATEMENTS

precompiled statement. See SYSTEM.FIPS_FEATURES.

FIPS_FEATURES

details about all FIPS features. See SYSTEM.FIPS_FEATURES.

FIPS_SIZING

details about FIPS limits. See SYSTEM.FIPS_SIZING.

KEY_COLUMN_USAGE

columns in an index or in a primary, unique or foreign key. SYSTEM.KEY_COLUMN_USAGE.

LEVEL2_RESTRICT

restrictions for domains legal for use by DB level 2. See SYSTEM.LEVEL2_RESTRICT.

LEVEL2_VIEWCOL

columns of views acceptable by DB level 2. See SYSTEM.LEVEL2_VIEWCOL.

LEVEL2_VIEWRES

restrictions for DB level 2. See SYSTEM.LEVEL2_VIEWRES.

MANYROWS

dummy table with more than one row. See SYSTEM.MANYROWS.

MESSAGE

translation of message code to message text. See SYSTEM.MESSAGE.

MODULES

SQL-server modules in the database. See SYSTEM.MODULES.

OBJECT_COLUMN_USE

columns referenced by other database objects. See SYSTEM.OBJECT_COLUMN_USE.

OBJECT_OBJECT_USE

objects that have a dependency on another object. See SYSTEM.OBJECT_OBJECT_USE.

OBJECTS

objects in the database. See SYSTEM.OBJECTS.

ONEROW

dummy table containing one row. See SYSTEM.ONEROW.

PARAMETERS

parameters of routines in the database. See SYSTEM.PARAMETERS.

REFER_CONSTRAINTS

referential constraints in the database. See SYSTEM.REFER_CONSTRAINTS.

ROUTINES

procedures and user-defined functions in the database. See SYSTEM.ROUTINES.

SCHEMATA

schemas in the database. See SYSTEM.SCHEMATA.

SEQUENCES

sequences in the database. See SYSTEM.SEQUENCES.

SERVER_INFO

attributes of the current database system or server. See SYSTEM.SERVER_INFO.

SEVERITY

severity levels and optional module for error codes. See SYSTEM.SEVERITY.

SOURCE_DEFINITION

source definitions for defaults, check constraints, views, modules, procedures, functions and triggers. See SYSTEM.SOURCE_DEFINITION.

SPECIFIC_NAMES

specific names of the routines in the database. See SYSTEM.SPECIFIC_NAMES.

SQL_CONFORMANCE

SQL functionality. See SYSTEM.SQL_CONFORMANCE.

SQL_LANGUAGES

SQL standards and SQL dialects supported. See SYSTEM.SQL_LANGUAGES.

STATEMENT_DESCRIPTORS

compiled code for statements. See SYSTEM.STATEMENT_DESCRIPTORS.

STATEMENT_ROUTINE_USE

compiled routine used by precompiled statements. See SYSTEM.STATEMENT_ROUTINE_USE.

SYNONYMS

synonyms and shadows in the database. See SYSTEM.SYNONYMS.

TABLE_CONSTRAINTS

table constraints in the database. See SYSTEM.TABLE_CONSTRAINTS.

TABLE_PRIVILEGES

instances of privileges granted on a table. See SYSTEM.TABLE_PRIVILEGES.

TABLE_TYPES

the types of table supported. See SYSTEM.TABLE_TYPES.

TABLES

tables and views in the database. See SYSTEM.TABLES.

TRANSLATIONS

character translations in the database. See SYSTEM.TRANSLATIONS.

TRIGGERED_COLUMNS

table columns explicitly specified in an UPDATE trigger event. See SYSTEM.TRIGGERED_COLUMNS.

TRIGGERS

triggers in the database. See SYSTEM.TRIGGERS.

TYPE_INFO

information about data types supported. See SYSTEM.TYPE_INFO.

USAGE_PRIVILEGES

instances of privileges which grant the right to use a database object. See SYSTEM.USAGE_PRIVILEGES.

USER_DEF_TYPES

user defined types in the database. See SYSTEM.USER_DEF_TYPES.

USERS

idents (GROUP, OS_USER, PROGRAM or USER) in the database. See SYSTEM.USERS.

VIEWS

views in the database. See SYSTEM.VIEWS.

SYSTEM.API_FUNCTION

Records translations of id to function or module name.

Column name

Data type

Description

MODULEID

INTEGER

System identifier for module.

API_FUNCTION

INTEGER

System identifier for function.

TEXT

CHAR(40)

Name of the function or module.

Primary key: MODULEID, API_FUNCTION

SYSTEM.AST_CODES

Records the binary representation of the search condition of views in the database (for internal use).

Column name

Data type

Description

AST_SYSID

INTEGER

System identifier for the view.

AST_VERSION

INTEGER

Current AST-revision version number.

SEQUENCE_NO

INTEGER

Sequence number within representation.

AST_LENGTH

INTEGER

Length of binary data in AST_CODE.

AST_CODE

VARCHAR(1200)

Binary representation of the view search condition.

Primary key: AST_SYSID, AST_VERSION, SEQUENCE_NO

SYSTEM.AST_SOURCES

Records the textual representation of view definitions and domains or tables with check constraints in the database (for internal use).

Column name

Data type

Description

ASTS_SYSID

INTEGER

System identifier for the object which the definition represents.

SEQUENCE_NO

INTEGER

Sequence number within representation.

ASTS_LENGTH

INTEGER

Length of representation.

ASTS_SOURCE

NCHAR VARYING(400)

Textual representation of view, domain or table.

Primary key: ASTS_SYSID, SEQUENCE_NO

SYSTEM.CHAR_SETS

Records character sets in the database.

Column name

Data type

Description

CHARSET_SYSID

INTEGER

The system identifier for the character set.

FORM_OF_USE

VARCHAR(128)

A user-defined name that indicates the form-of-use of the character set.

NUMBER_OF_CHARS

INTEGER

Number of characters in the character set.

DEF_COLLATE_SYSID

INTEGER

System identifier for the character collation.

Primary key: CHARSET_SYSID

SYSTEM.CHECK_CONSTRAINTS

Records check constraints defined for tables and domains in the database.

Column name

Data type

Description

CONSTRAINT_SYSID

INTEGER

System identifier for the check constraint.

CHECK_CLAUSE

NCHAR VARYING(200)

The text of the search condition of the check constraint.

If the text is too long or NULL value, it will be stored in the SOURCE_DEFINITION table.

Primary key: CONSTRAINT_SYSID

SYSTEM.COLLATE_DEFS

Records collation definitions in the database.

Column name

Data type

Description

COLLATION_SYSID

INTEGER

System identifier for the collation.

COLLATION_SEQNO

INTEGER

Sequence number for each row of a definition (starts by 1).

COLLATION_TYPE

INTEGER

Internal identification for the base of the collation.

FROM_COLLATION_SYSID

INTEGER

System identifier for the collation on which this collation is based.

COLLATION_DEF_CHAR_LENGTH

INTEGER

Total length of the collation definition in number of characters.

COLLATION_DEF_CHAR_OFFSET

INTEGER

Offset to where the delta string for this collation starts in the definition.

COLLATION_DEF

NCHAR VARYING(800)

Complete collation definition for this collation (i.e. including the base collation).

Primary key: COLLATION_SYSID, COLLATION_SEQNO

SYSTEM.COLLATIONS

Records character collations in the database.

Column name

Data type

Description

COLLATION_SYSID

INTEGER

System identifier for the collation.

CHARSET_SYSID

INTEGER

System identifier for the character set.

PAD_ATTRIBUTE

CHAR(20)

One of the following values:
NO PAD = the collation has the no pad attribute PAD SPACE = the collation has the pad space attribute.

Primary key: COLLATION_SYSID

SYSTEM.COLUMNS

Records table and view columns in the database.

Column name

Data type

Description

TABLE_SYSID

INTEGER

System identifier for the table or view.

COLUMN_NAME

VARCHAR(128)

The name of the table or view column.

ORDINAL_POSITION

INTEGER

The ordinal position of the column in the table. The first column in the table is number 1.

DOMAIN_SYSID

INTEGER

System identifier for the domain used by the column.

COLLATION_SYSID

INTEGER

System identifier for the collation used by the column.

CHARSET_SYSID

INTEGER

System identifier for the character set used by the column.

UDT_SYSID

INTEGER

System identifier for a user-defined type.

DATA_TYPE

CHAR(30)

Identifies the data type of the column.
Can be one of the following:
BIGINT
BINARY
BINARY VARYING
BINARY LARGE OBJECT
CHARACTER
CHARACTER VARYING
CHARACTER LARGE OBJECT
NATIONAL CHARACTER
NATIONAL CHARACTER VARYING
NATIONAL CHAR LARGE OBJECT
DATE
DECIMAL
DOUBLE PRECISION
FLOAT
Float(p)
INTEGER
Integer(p)
INTERVAL
NUMERIC
REAL
SMALLINT
TIME
TIMESTAMP.

INTERVAL_TYPE

CHAR(30)

For INTERVAL data types, this is a character string specifying the interval qualifier for the named interval data type, see the Mimer SQL Reference Manual.

For other data types it is the NULL value.

CHAR_MAX_LENGTH

BIGINT

For CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in characters or bytes as appropriate.

For all other data types it is the NULL value.

CHAR_OCTET_LENGTH

BIGINT

For a CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in octets.

For all other data types it is the NULL value. (For single octet character sets, this is the same as CHAR_MAX_LENGTH.)

NUMERIC_PRECISION

INTEGER

For NUMERIC data types, this shows the total number of decimal digits allowed in the column.

For all other data types it is the NULL value. NUMERIC_PREC_RADIX indicates the units of measurement.

NUMERIC_SCALE

INTEGER

For NUMERIC data types, this shows the total number of significant digits to the right of the decimal point. For INTEGER values this is 0. For all other types, it is the NULL value.

NUMERIC_PREC_RADIX

INTEGER

For NUMERIC data types, the value 10 is shown because NUMERIC_PRECISION specifies a number of decimal digits. For all other data types it is the NULL value. NUMERIC_PRECISION and NUMERIC_PREC_RADIX can be combined to calculate the maximum number that the column can hold.

DATETIME_PRECISION

INTEGER

For DATE, TIME, TIMESTAMP and interval data types, this column contains the number of digits of precision for the fractional seconds component.

For other data types it is the NULL value.

INTERVAL_PRECISION

INTEGER

For INTERVAL data types, this is the number of significant digits for the interval leading precision, see the Mimer SQL Reference Manual.

For other data types it is the NULL value.

IS_NULLABLE

CHAR(3)

One of:
NO = the column is not nullable, according to the rules in the international standard
YES = the NULL value is allowed in the column.

IS_UPDATABLE

CHAR(3)

One of:
NO = the column is not updatable
YES = the column is updatable.

IS_INSTEAD_OF

CHAR(3)

One of:
NO
YES.

INTERNAL_LENGTH

INTEGER

Internal length in bytes of value.

INTERNAL_OFFSET

INTEGER

Internal offset for value in record.

INTERNAL_VC_OFFSET

INTEGER

Internal offset for field containing actual length for a varying length item.

COLUMN_CARD

BIGINT

Number of unique values in column.

COLUMN_CARD_NONULL

BIGINT

Number of values in column that are not null.

COLUMN_LOW_VALUE

CHAR(16)

Lowest value in column.

COLUMN_HIGH_VALUE

CHAR(16)

Highest value in column.

COLUMN_DEFAULT

NCHAR VARYING(200)

This shows the default value for the column.

If the default value is a CHARACTER string, the value shown is the string enclosed in single quotes.

If the default value is a NUMERIC LITERAL, the value is shown in its original character representation without enclosing quotes.

If the default value is a DATE, TIME or TIMESTAMP, the value shown is the appropriate keyword (e.g. DATE) followed by the literal representation of the value enclosed in single quotes, see the Mimer SQL Reference Manual for a description of DATE, TIME and TIMESTAMP literals).

If the default value is a pseudo-literal, the value shown is the appropriate keyword (e.g. CURRENT_DATE) without enclosing quotes.

If the default value is the NULL value, the value shown is the keyword NULL without enclosing quotes.

If the default value cannot be represented without truncation, then a zero-length string is stored.

If no default value was specified then its value is the NULL value.

The value of COLUMN_DEF is syntactically suitable for use in specifying default-value in a CREATE TABLE or ALTER TABLE statement.

REMARKS

NCHAR VARYING(254)

A comment on the column. If no comment has been defined a zero length string is stored.

Primary key: TABLE_SYSID, COLUMN_NAME

Unique constraint: TABLE_SYSID, ORDINAL_POSITION

Secondary index: TABLE_SYSID, INTERNAL_OFFSET

SYSTEM.COLUMN_OBJECT_USE

Records table or view columns that depend on other objects in the database.

.

Column name

Data type

Description

OBJECT_TYPE

CHAR(20)

One of:
DOMAIN
SEQUENCE
COLLATION.

OBJECT_SYSID

INTEGER

System identifier for the object on which the column depends.

TABLE_SYSID

INTEGER

System identifier for the table or view.

COLUMN_NAME

VARCHAR(128)

The name of the table or view column.

Primary key: OBJECT_TYPE, OBJECT_SYSID, TABLE_SYSID, COLUMN_NAME

Secondary index: TABLE_SYSID, COLUMN_NAME

SYSTEM.COLUMN_PRIVILEGES

Records instances of privileges granted on a column.

.

Column name

Data type

Description

TABLE_SYSID

INTEGER

System identifier for the table or view.

COLUMN_NAME

VARCHAR(128)

The name of the table or view column.

PRIVILEGE_TYPE

CHAR(20)

One of:
INSERT
REFERENCES
SELECT
UPDATE.

GRANTEE

VARCHAR(128)

The name of the ident to whom the privilege was granted.

GRANTOR

VARCHAR(128)

The name of the ident granting the privilege.

IS_GRANTABLE

CHAR(3)

One of:
NO = WITH GRANT OPTION is not held for the privilege
YES = WITH GRANT OPTION is held for the privilege.

IS_INSTEAD_OF

CHAR(3)

One of:
NO = The privilege has been granted explicitly
YES = The privilege is granted because an instead of trigger has been defined on the view to which the column belongs.

Primary key: TABLE_SYSID, COLUMN_NAME, PRIVILEGE_TYPE, GRANTEE, GRANTOR

Secondary index: GRANTEE

Secondary index: GRANTOR

SYSTEM.DATABANKS

Records the databanks in the database.

Column name

Data type

Description

DATABANK_SYSID

INTEGER

System identifier for the databank.

DATABANK_SEQNO

INTEGER

The shadowing sequence number for the databank.

DATABANK_FILENO

INTEGER

The file number of the databank file.

DATABANK_NAME

VARCHAR(128)

The name of the databank.

SHADOW_NAME

VARCHAR(128)

The shadow name if the databank is a shadow.

DATABANK_FILENAME

NCHAR VARYING(256)

The path name for the databank file.

DATABANK_TYPE

CHAR(20)

Indicates type of transaction handling:
LOG = transaction handling with logging
READ ONLY = allows read operations only
TEMPORARY = work databank (SQLDB)
TRANSACTION = transaction handling without logging
WORK = transaction handling not used

IS_MASTER

CHAR(3)

One of:
NO = the databank is a shadow
YES = the databank is a master.

IS_ONLINE

CHAR(3)

One of:
NO = the databank is OFFLINE
YES = the databank of ONLINE.

LOBDIR_SYSID

INTEGER

System identifier for the large object directory in the databank.

LOBDATA_SYSID

INTEGER

System identifier for the large object table in the databank

MAXSIZE

BIGINT

Maximum size for databank file, kilo bytes

GOALSIZE

BIGINT

Ideal size for databank file, kilo bytes

MINSIZE

BIGINT

Minimum size for databank file, kilo bytes

IS_REMOVABLE

CHAR(3)

One of:
NO = databank is not removable
YES = databank is removable

BACKUPED

TIMESTAMP(2)

Last date for backup, currently always set to NULL

Primary key: DATABANK_SYSID, DATABANK_SEQNO, DATABANK_FILENO

Unique constraint: SHADOW_NAME, DATABANK_FILENO

Secondary index: DATABANK_NAME, DATABANK_SEQNO

SYSTEM.DOMAINS

Records the domains in the database.

Column name

Data type

Description

DOMAIN_SYSID

INTEGER

System identifier for the domain.

CHARSET_SYSID

INTEGER

System identifier for the character set.

COLLATION_SYSID

INTEGER

System identifier for the collation for a domain associated with a character set.

DATA_TYPE

CHAR(30)

Identifies the data type of the domain.
Can be one of the following:
BIGINT
BINARY
BINARY VARYING
BINARY LARGE OBJECT
CHARACTER
CHARACTER VARYING
CHARACTER LARGE OBJECT
NATIONAL CHARACTER
NATIONAL CHARACTER VARYING
NATIONAL CHAR LARGE OBJECT
DATE
DECIMAL
DOUBLE PRECISION
FLOAT
Float(p)
INTEGER
Integer(p)
INTERVAL
NUMERIC
REAL
SMALLINT
TIME
TIMESTAMP.

INTERVAL_TYPE

CHAR(30)

For INTERVAL data types, this is a character string specifying the interval qualifier for the named interval data type, see the Mimer SQL Reference Manual.

For other data types it is the NULL value.

CHAR_MAX_LENGTH

BIGINT

For CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in characters or bytes as appropriate.

For all other data types it is the NULL value.

CHAR_OCTET_LENGTH

BIGINT

For a CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in octets.

For all other data types it is the NULL value. (For single octet character sets, this is the same as CHAR_MAX_LENGTH.)

NUMERIC_PRECISION

INTEGER

For NUMERIC data types, this shows the total number of decimal digits allowed in the column.

For all other data types it is the NULL value. NUMERIC_PREC_RADIX indicates the units of measurement.

NUMERIC_SCALE

INTEGER

This defines the total number of significant digits to the right of the decimal point.

For INTEGER and SMALLINT, this is 0.

For CHARACTER, VARCHAR, DATETIME, FLOAT, INTERVAL, REAL and DOUBLE PRECISION data types, it is the NULL value.

NUMERIC_PREC_RADIX

INTEGER

For NUMERIC data types, the value 10 is shown because NUMERIC_PRECISION specifies a number of decimal digits.

For all other data types it is the NULL value.

NUMERIC_PRECISION and NUMERIC_PREC_RADIX can be combined to calculate the maximum number that the column can hold.

DATETIME_PRECISION

INTEGER

For DATE, TIME, TIMESTAMP and interval data types, this column contains the number of digits of precision for the fractional seconds component.

For other data types it is the NULL value.

INTERVAL_PRECISION

INTEGER

For INTERVAL data types, this is the number of significant digits for the interval leading precision, see the Mimer SQL Reference Manual.

For other data types it is the NULL value.

INTERNAL_LENGTH

INTEGER

Internal length in bytes of value.

DOMAIN_DEFAULT

NCHAR VARYING(200)

This shows the default value for the domain.

If the default value is a character string, the value shown is the string enclosed in single quotes.

If the default value is a numeric literal, the value is shown in its original character representation without enclosing quotes.

If the default value is a DATE, TIME or TIMESTAMP, the value shown is the appropriate keyword (e.g. DATE) followed by the literal representation of the value enclosed in single quotes, see Mimer SQL Reference Manual for a description of DATE, TIME and TIMESTAMP literals.

If the default value is a pseudo-literal, the value shown is the appropriate keyword (e.g. CURRENT_DATE) without enclosing quotes.

If the default value is the NULL value, the value shown is the keyword NULL without enclosing quotes.

If the default value cannot be represented without truncation, then a zero-length string is stored.

If no default value was specified then its value is the NULL value.

The value of DOMAIN_DEFAULT is syntactically suitable for use in specifying default-value in a CREATE TABLE or ALTER TABLE statement.

ANY_CONSTRAINT

CHAR(3)

One of:
NO = There are no constraints for the domain
YES = There are constraints for the domain.

IS_LEVEL2_APPROVED

CHAR(3)

One of:
NO = Tables using this domain can not be used with the level 2 interface
YES = The use of this domain does not prohibit the table being used with the level 2 interface.

Primary key: DOMAIN_SYSID

SYSTEM.DOMAIN_CONSTRAINTS

Records the constraints defined for domains in the database.

.

Column name

Data type

Description

DOMAIN_SYSID

INTEGER

System identifier for the domain.

CONSTRAINT_SYSID

INTEGER

System identifier for the constraint.

IS_DEFERRABLE

CHAR(3)

One of:
NO = the constraint is not deferrable.
YES = the constraint is deferrable.

INITIALLY_DEFERRED

CHAR(3)

One of:
NO = the constraint is not initially deferred
YES = the constraint is initially deferred.

Primary key: DOMAIN_SYSID, CONSTRAINT_SYSID

SYSTEM.EXEC_STATEMENTS

Records precompiled statements in the database.

Column name

Data type

Description

STATEMENT_SYSID

INTEGER

System identifier for the precompiled statement.

STATEMENT_TYPE

INTEGER

Type of statement (internal value).

STATEMENT_SOURCE

NCHAR VARYING(200)

Source text for the precompiled statement. If the length exceeds 400 characters, this value is NULL and the source text is stored in SOURCE_DEFINITION.

STATEMENT_SOU_LENGTH

CHAR(3)

Length of source text in characters.

SYSTEM.FIPS_FEATURES

Lists details of all FIPS features.

Column name

Data type

Description

FEATURE_ID

SMALLINT

Identification number of the FIPS feature.

FEATURE_NAME

CHAR(50)

The name of the FIPS feature.

CLASSIFICATION

CHAR(12)

The conformance level of the feature.
One of:
TRANSITIONAL
INTERMEDIATE
FULL.

IS_SUPPORTED

CHAR(3)

One of:
YES = Mimer SQL supports the feature
NO = Mimer SQL does not support the feature.

IS_VERIFIED

CHAR(3)

One of:
YES = Mimer SQL support for the feature has been tested and verified
NO = Mimer SQL support for the feature has not been verified.

FEATURE_COMMENTS

VARCHAR(100)

Comments about the feature.

Primary key: FEATURE_ID

SYSTEM.FIPS_SIZING

Lists details about FIPS limits.

Column name

Data type

Description

SIZING_ID

SMALLINT

Identification number for limit.

DESCRIPTION

CHAR(50)

Description of limit.

ENTRY_VALUE

INTEGER

Limit for entry SQL.

INTERMEDIATE_VALUE

INTEGER

Limit for intermediate SQL.

VALUE_SUPPORTED

INTEGER

Limit for Mimer SQL.

SIZING_COMMENTS

VARCHAR(100)

Comments for limit.

Primary key: SIZING_ID

SYSTEM.KEY_COLUMN_USAGE

Records columns in an index or in a primary, unique or foreign key.

Column name

Data type

Description

TABLE_SYSID

INTEGER

System identifier for the table.

CONSTRAINT_SYSID

INTEGER

System identifier for the table constraint.

ORDINAL_POSITION

INTEGER

The ordinal position of the column in the table.

The first column in the table is number 1.

COLUMN_NAME

VARCHAR(128)

The name of the table column.

KEY_TYPE

CHAR(20)

One of:
FOREIGN KEY
INDEX
INTERNAL KEY
PRIMARY KEY
UNIQUE.

IS_UNIQUE

CHAR(3)

One of:
NO = the column may contain non-unique values
YES = the column is constrained to contain only unique values.

IS_ASCENDING

CHAR(3)

One of:

NO = the column is indexed in descending value order
YES = the column is indexed in ascending value order.

COLLATION_SYSID

INTEGER

System identifier for the collation used by the index.

Primary key: TABLE_SYSID, CONSTRAINT_SYSID, ORDINAL_POSITION

Unique constraint: CONSTRAINT_SYSID, COLUMN_NAME

SYSTEM.LEVEL2_RESTRICT

Records restrictions for domains legal for use by DB level 2.

Column name

Data type

Description

DOMAINID

INT(10)

System identifier for the domain with restrictions.

SEQNO

INT(3)

Restriction order number.

LOGOP

CHAR(3)

Logical operator (AND, OR).

RELOP

CHAR(2)

Relational operator (EQ, ...).

LENGTH

INT(5)

Length of the value.

RESVALUE

CHAR(64)

Restriction value.

Primary key: DOMAINID, SEQNO

SYSTEM.LEVEL2_VIEWCOL

Records columns of views acceptable by DB level 2.

Column name

Data type

Description

VTABID

INT(10)

View table identifier.

VCOLNO

INT(3)

View table column number.

BTABID

INT(10)

Base table identifier.

BCOLNO

INT(3)

Base table column number.

Primary key: VTABID, VCOLNO

SYSTEM.LEVEL2_VIEWRES

Records restrictions for DB level 2.

Column name

Data type

Description

VTABID

INT(10)

View table identifier.

SEQNO

INT(3)

Restriction order number.

LOGOP

CHAR(3)

Logical operator (AND, OR).

BTABID

INT(10)

Base table identifier.

BCOLNO

INT(3)

Base table column number.

RELOP

CHAR(2)

Relational operator (EQ, ...).

LENGTH

INT(5)

Length of the value.

RESVALUE

CHAR(64)

Restriction value.

Primary key: VTABID, SEQNO

SYSTEM.MANYROWS

Dummy table with more than row.

Column name

Data type

Description

C

INT(3)

The values column.

Primary key: C

SYSTEM.MESSAGE

Records translations of message codes to message text.

Column name

Data type

Description

MODULEID

INTEGER

Identification number for Mimer SQL module to which error belongs.

MESSAGEID

INTEGER

Identification number for message

LANGUAGE

INTEGER

Language number for message
1 = English.

LINENO

INTEGER

Line number for message.

MESSAGE

CHAR(80)

Message text.

Primary key: MODULEID, MESSAGEID, LANGUAGE, LINENO

SYSTEM.MODULES

Records the SQL-server modules in the database.

Column name

Data type

Description

MODULE_SYSID

INTEGER

System identifier for the module.

DEF_CHARSET_SYSID

INTEGER

System identifier for the default character set for the module.

DEF_SCHEMA_SYSID

INTEGER

System identifier for the default schema for the module.

MODULE_LENGTH

INTEGER

Length of the module definition.

MODULE_DEFINITION

NCHAR VARYING(200)

Source text for module definition, if the length of the module definition exceeds 200 characters, this value is NULL and the source text is stored in SOURCE_DEFINITION.

SQL_PATH

VARCHAR(200)

The path for the module.

Primary key: MODULE_SYSID

SYSTEM.OBJECTS

Records objects in the database.

Column name

Data type

Description

OBJECT_SYSID

INTEGER

System identifier for the database object.

OBJECT_TYPE

VARCHAR(20)

One of:
BASE TABLE
CHARACTER SET
COLLATION
CONSTRAINT
DATABANK
DOMAIN
FUNCTION
INDEX
IDENT
MODULE
PROCEDURE
SCHEMA
SEQUENCE
SHADOW
STATEMENT
SYNONYM
TRANSLATION
TRIGGER
VIEW.

OBJECT_SCHEMA

VARCHAR(128)

The name of the schema containing the object.

OBJECT_NAME

VARCHAR(128)

The name of the object.

OBJECT_CREATED

TIMESTAMP(2)

The date and time the object was created.

OBJECT_ALTERED

TIMESTAMP(2)

The date and time the object was last altered.

REMARKS

NCHAR VARYING(254)

Comments defined on the object. If there is no comment defined the empty string ("") will appear. Remarks relating to columns will be stored in the COLUMNS table.

Primary key: OBJECT_SYSID

Unique constraint: OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME

SYSTEM.OBJECT_COLUMN_USE

Records columns referenced by other database objects.

Column name

Data type

Description

TABLE_SYSID

INTEGER

System identifier for the table.

COLUMN_NAME

VARCHAR(128)

The name of the table column.

USED_BY_SYSID

INTEGER

The system identifier of the referencing object.

USED_BY_TYPE

CHAR(20)

One of:
VIEW
PROCEDURE
FUNCTION
CHECK
TRIGGER
STATEMENT.

PRIVILEGE_TYPE

CHAR(20)

One of:
INSERT
DELETE
SELECT
UPDATE
REFERENCES.

Primary key: TABLE_SYSID, COLUMN_NAME, USED_BY_SYSID, USED_BY_TYPE, PRIVILEGE_TYPE

Secondary index: USED_BY_SYSID, USED_BY_TYPE

SYSTEM.OBJECT_OBJECT_USE

Records objects referenced by other objects.

Column name

Data type

Description

OBJECT_SYSID

INTEGER

System identifier for the object used.

OBJECT_TYPE

CHAR(20)

One of:
BASE TABLE
VIEW
PROCEDURE
FUNCTION
DOMAIN
SEQUENCE
CHARACTER SET
COLLATION
TRANSLATION.

USED_BY_SYSID

INTEGER

The system identifier of the referencing object.

USED_BY_TYPE

CHAR(20)

One of:
BASE_TABLE
VIEW
PROCEDURE
FUNCTION
DOMAIN
TRIGGER
CHARACTER SET
COLLATION
TRANSLATION
CHECK
INDEX
STATEMENT.

IS_STRONG

CHAR(3)

One of:
NO
YES.

Primary key: OBJECT_SYSID, OBJECT_TYPE, USED_BY_SYSID, USED_BY_TYPE

Secondary index: USED_BY_SYSID, USED_BY_TYPE

SYSTEM.ONEROW

Dummy table containing one row.

Column name

Data type

Description

M

CHAR(1)

Contains the value M.

Primary key: M

SYSTEM.PARAMETERS

Records parameters of routines in the database.

Column name

Data type

Description

ROUTINE_SYSID

INTEGER

System identifier for the function or procedure.

ORDINAL_POSITION

INTEGER

The ordinal position of the parameter in the routine. The first parameter in the routine is number 1.

IS_RESULT

CHAR(3)

One of:
NO = This parameter is not part of the result clause for a result set procedure
YES = This parameter is part of the result set.

PARAMETER_MODE

CHAR(5)

One of:
IN
OUT
INOUT.

PARAMETER_NAME

VARCHAR(128)

The name of the parameter.

DOMAIN_SYSID

INTEGER

System identifier of the domain that defines the data type of the parameter.

COLLATION_SYSID

INTEGER

System identifier of the collation associated with the parameter.

CHARSET_SYSID

INTEGER

The system identifier for the character set.

UDT_SYSID

INTEGER

System identifier for a user-defined type.

DATA_TYPE

CHAR(30)

The data type of the parameter.

INTERVAL_TYPE

CHAR(30)

For INTERVAL data types, this is a character string specifying the interval qualifier for the named interval data type, see the Mimer SQL Reference Manual.

For other data types it is the NULL value.

CHAR_MAX_LENGTH

BIGINT

For CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in characters or bytes as appropriate.

For all other data types it is the NULL value.

CHAR_OCTET_LENGTH

BIGINT

For a CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in octets.

For all other data types it is the NULL value. (For single octet character sets, this is the same as CHAR_MAX_LENGTH.)

NUMERIC_PRECISION

INTEGER

For NUMERIC data types, this shows the total number of decimal digits allowed in the column.

For all other data types it is the NULL value. NUMERIC_PREC_RADIX indicates the units of measurement.

NUMERIC_SCALE

INTEGER

This defines the total number of significant digits to the right of the decimal point. For INTEGER and SMALLINT, this is 0. For CHARACTER, VARCHAR, DATETIME, FLOAT, INTERVAL, REAL and DOUBLE PRECISION data types, it is the NULL value.

NUMERIC_PREC_RADIX

INTEGER

For numeric data types, the value 10 is shown because NUMERIC_PRECISION specifies a number of decimal digits.

For all other data types it is the NULL value.

NUMERIC_PRECISION and NUMERIC_PREC_RADIX can be combined to calculate the maximum number that the column can hold.

DATETIME_PRECISION

INTEGER

For DATE, TIME, TIMESTAMP and INTERVAL data types, this column contains the number of digits of precision for the fractional seconds component.

For other data types it is the NULL value.

INTERVAL_PRECISION

INTEGER

For INTERVAL data types, this is the number of significant digits for the interval leading precision, see the Mimer SQL Reference Manual.

For other data types it is the NULL value.

Primary key: ROUTINE_SYSID, ORDINAL_POSITION, IS_RESULT

SYSTEM.REFER_CONSTRAINTS

Records referential constraints in the database.

Column name

Data type

Description

TABLE_SYSID

INTEGER

System identifier for the table.

CONSTRAINT_SYSID

INTEGER

System identifier for the referential constraint.

UNIQUE_TABLE_SYSID

INTEGER

System identifier for the table that is referenced in the foreign key.

UNIQUE_CONST_SYSID

INTEGER

System identifier for the constraint that is (implicitly) referenced in the foreign key.

MATCH_OPTION

CHAR(20)

One of:
NONE
PARTIAL
FULL.

UPDATE_RULE

CHAR(20)

One of:
CASCADE
SET NULL
SET DEFAULT
NO ACTION
RESTRICT.

DELETE_RULE

CHAR(20)

One of:
CASCADE
SET NULL
SET DEFAULT
NO ACTION
RESTRICT.

Primary key: TABLE_SYSID, CONSTRAINT_SYSID

Secondary index: UNIQUE_TABLE_SYSID, UNIQUE_CONST_SYSID

SYSTEM.ROUTINES

Records procedures and user-defined functions in the database.

Column name

Data type

Description

ROUTINE_SYSID

INTEGER

System identifier of the function or procedure.

MODULE_SYSID

INTEGER

System identifier of the module to which the routine belongs.

ROUTINE_TYPE

CHAR(20)

One of:
PROCEDURE
FUNCTION.

SQL_DATA_ACCESS

CHAR(20)

One of:
NO SQL
CONTAINS SQL
READS SQL DATA
MODIFIES SQL DATA.

ROUTINE_OFFSET

INTEGER

Offset for routine within module definition.

This value is zero if the routine ins not defined in a module.

ROUTINE_LENGTH

INTEGER

Length of routine definition

TOTAL_PARAMS

INTEGER

The total number of routine parameters.

RESULT_PARAMS

INTEGER

The number of result parameters.

INPUT_PARAMS

INTEGER

The number of input parameters.

OUTPUT_PARAMS

INTEGER

The number of output parameters.

ROUTINE_DEFINITION

NCHAR VARYING(200)

Routine definition.

If the length of the routine definition exceeds 400 characters, this value is NULL and the source text is stored in SOURCE_DEFINITION.

SQL_PATH

VARCHAR(200)

The search path for the routine.

IS_DETERMINISTIC

CHAR(3)

One of:
NO = The routine is not deterministic. i.e. invoking the routine with the same input values is not guaranteed to return the same result
YES = The routine is deterministic, i.e. when invoked with same input values it will always return the same result.

ROUTINE_BODY

CHAR(20)

One of:
SQL = The routine is an SQL routine
EXTERNAL = The routine is external

EXTERNAL_NAME

VARCHAR(128)

The name of the program that implements the routine if it is an external routine otherwise null.

EXTERNAL_LANGUAGE

CHAR(20)

The language for the routine if it is external otherwise null.

PARAMETER_STYLE

CHAR(20)

The parameter passing style for the routine if it is an external routine, otherwise null.

SCHEMA_LEVEL_ROU

CHAR(3)

One of:
NO = The routine is defined within a module
YES = The routine is not defined in a module.

MX_DYN_RESULT_SETS

INTEGER

The maximal number of result sets that the routine may return.

UDT_SYSID

INTEGER

(currently not used)

IS_USER_DEFINED_CAST

CHAR(3)

(currently not used)

IS_IMPLICITLY_INVOCABLE

CHAR(3)

(currently not used)

MS_SYSID

INT

(currently not used)

Primary key: ROUTINE_SYSID

Secondary index: MODULE_SYSID

SYSTEM.SCHEMATA

Records schemas in the database.

Column name

Data type

Description

SCHEMA_SYSID

INTEGER

System identifier of the schema.

DEF_CHARSET_SYSID

INTEGER

System identifier of the default character set.

SQL_PATH

VARCHAR(200)

The default search path for objects belonging to the schema.

Primary key: SCHEMA_SYSID

SYSTEM.SEQUENCES

Records sequences in the database.

Column name

Data type

Description

SEQUENCE_SYSID

INTEGER

System identifier of the sequence.

DATA_TYPE

CHAR(30)

One of:
SMALLINT
INTEGER
BIGINT.

NUMERIC_PRECISION

INTEGER

Precision for data type.

MAXIMUM_VALUE

BIGINT

The maximum value of the sequence.

MINIMUM_VALUE

BIGINT

The minimum value of the sequence.

INCREMENT

BIGINT

The increment value for sequence.

CYCLE_OPTION

CHAR(3)

One of:
'YES ' = the sequence will restart when all values are exhausted
'NO ' = the sequence will not restart when all values are exhausted.

START_VALUE

BIGINT

Start value for sequence when first used.

CURRENT_VALUE

BIGINT

Start value at system start up.

IS_EXHAUSTED

CHAR(3)

One of:
YES = the series of values defined by the sequence is exhausted
NO = the series of values defined by the sequence is not exhausted.

CYCLES

BIGINT

Number of times the maximum value of the sequence is exceeded.

DATABANK_SYSID

INTEGER

Databank location.

Primary key: SEQUENCE_SYSID

SYSTEM.SERVER_INFO

Records attributes of the current database system or server.

Column name

Data type

Description

SERVER_ATTRIBUTE

VARCHAR(254)

One of:
AUTOUPGRADE_ENABLED
CATALOG_NAME
COLLATION_SEQ
CURRENT_COLLATION_ID
IDENTIFIER_LENGTH
INTERVAL_FRAC_PREC
INTERVAL_LEAD_PREC
ROW_LENGTH
TIME_PREC
TIMESTAMP_PREC
TXN_ISOLATION
USERID_LENGTH
CATALOG_VERSION_CREATED
CATALOG_VERSION_CURRENT.

ATTRIBUTE_VALUE

VARCHAR(254)

The value for the attribute.

Primary key: SERVER_ATTRIBUTE

SYSTEM.SEVERITY

Records severity levels and optional module for error codes.

Column name

Data type

Description

MODULEID

INTEGER

Identification number for the Mimer SQL module to which the message belongs.

MESSAGEID

INTEGER

Identification number for message.

SEVERITY

INTEGER

Severity for message:
1 = Message
2 = Warning
3 = Error
4 = Fatal error
5 = Internal error
6 = Code.

MODULE

CHAR(20)

Name of Mimer SQL module to which the message belongs.

SQLSTATE_VALUE

CHAR(5)

Corresponding SQLSTATE value for message.

CLASS_ORIGIN

CHAR(20)

Class origin for the SQLSTATE value.

SUBCLASS_ORIGIN

CHAR(20)

Sub class origin for the SQLSTATE value.

Primary key: MODULEID, MESSAGEID

SYSTEM.SOURCE_DEFINITION

Records source definitions for defaults, check constraints, views, modules, procedures, functions, triggers and statements.

Column name

Data type

Description

SOURCE_SYSID

INTEGER

System identifier of the source definition.

COLUMN_NAME

VARCHAR(128)

Column name if the source types is a default value for a column.

SOURCE_TYPE

CHAR(20)

One of:
DEFAULT
CHECK
VIEW
ROUTINE
STATEMENT.

SEQUENCE_NO

INTEGER

Sequence number in source definition.

SOURCE_LENGTH

INTEGER

The length of the stored source text.

SOURCE_DEFINITION

NCHAR VARYING(400)

The stored source text.

Primary key: SOURCE_SYSID, COLUMN_NAME, SOURCE_TYPE, SEQUENCE_NO

SYSTEM.SPECIFIC_NAMES

Records specific names of the routines in the database.

Column name

Data type

Description

ROUTINE_SYSID

INTEGER

System identifier of the routine.

SPECIFIC_SCHEMA

VARCHAR(128)

The name of the schema containing the routine.

SPECIFIC_NAME

VARCHAR(128)

The specific name for the routine.

UDT_SYSID

INTEGER

(currently not used)

Primary key: ROUTINE_SYSID

Unique constraint: SPECIFIC_SCHEMA, SPECIFIC_NAME

SYSTEM.SQL_CONFORMANCE

The SQL_CONFORMANCE base table has one row for each conformance element identified by ISO/IEC 9075.

Column name

Data type

Description

CONFORMANCE_ID

CHAR(20)

Identification of the conformance element described.

CONFORMANCE_SUB_ID

CHAR(20)

If the conformance element is a subfeature then it's identification, otherwise a single space.

CONFORMANCE_TYPE

CHAR(20)

Type of conformance element. FEATURE, SUBFEATURE, PACKAGE, or PART.

CONFORMANCE_IS_CORE_SQL

CHAR(3)

YES if the conformance element belongs to Core SQL, otherwise NO.

CONFORMANCE_NAME

VARCHAR(100)

Short description of the conformance element.

CONFORMANCE_SUB_NAME

VARCHAR(100)

Short description of a subfeature, otherwise a single space.

CONFORMANCE_IS_SUPPORTED

CHAR(3)

YES if fully supported by Mimer SQL, otherwise NO.

CONFORMANCE_IS_VERIFIED_BY

CHAR(3)

Should identify conformance test used to verify the conformance (always NULL).

CONFORMANCE_REMARKS

VARCHAR(100)

Comments pertinent to the conformance element.

Primary key: CONFORMANCE_ID, CONFORMANCE_SUB_ID

SYSTEM.SQL_LANGUAGES

Records the SQL standards and SQL dialects supported.

Column name

Data type

Description

SOURCE

VARCHAR(100)

Body that has defined standard.

SOURCE_YEAR

VARCHAR(100)

Which year the standard was approved.

CONFORMANCE

VARCHAR(100)

Level of conformance within standard.

INTEGRITY

VARCHAR(100)

If the supported standard is ISO 9075 the value YES in this column means that the integrity enhancement feature of this standard is supported, otherwise the value of this column is null.

IMPLEMENTATION

VARCHAR(100)

Implementation style, always null in Mimer SQL.

BINDING_STYLE

VARCHAR(100)

One of:
DIRECT = Support for interactive (ad hoc) access to the database
EMBEDDED = Support for access through an application programming interface.

PROGRAMMING_LANG

VARCHAR(100)

Name of programming languages that are supported if the binding style is EMBEDDED.

ORDINAL_NO

INTEGER

Ordinal number.

Primary key: SOURCE, SOURCE_YEAR, ORDINAL_NO

SYSTEM.STATEMENT_DESCRIPTORS

Records compiled code for precompiled statements.

Column name

Data type

Description

STATEMENT_SYSID

INTEGER

System identifier for the precompiled statement.

DESC_MODE

INTEGER

Mode, one of:
1 = no scroll
2 = scroll

DESC_TYPE

INTEGER

Internal. Naming or section descriptor type.

DESC_SEQNO

INTEGER

Sequence number for compiled code.

DESC_CODE_LENGTH

INTEGER

Length of compiled code.

DESC_CODE

BINARY(1000)

Compiled code.

DESC_VERSION

INTEGER

Compiler version used.

SYSTEM.STATEMENT_ROUTINE_USE

Records compiled routines used by precompiled statements.

Column name

Data type

Description

STATEMENT_SYSID

INTEGER

System identifier for the precompiled statement.

USE_SEQNO

INTEGER

Sequence number.

USE_LEVEL

INTEGER

Call level for routine.

USE_ROUTINE_SYSID

INTEGER

System identifier for called routines.

SYSTEM.SYNONYMS

Records synonyms and shadows in the database.

Column name

Data type

Description

SYNONYM_SYSID

INTEGER

System identifier of the synonym.

ORDINARY_SYSID

INTEGER

System identifier of the original object.

Primary key: SYNONYM_SYSID

SYSTEM.TABLES

Records tables and views in the database.

Column name

Data type

Description

TABLE_SYSID

INTEGER

System identifier of the table or view.

TABLE_TYPE

CHAR(20)

One of:
BASE TABLE
VIEW.

TABLE_NOCOLS

INTEGER

Number of columns in table.

TABLE_RECLEN

INTEGER

Record length for table.

TABLE_CARD

BIGINT

Number of records in table.

STATISTIC_GATHERED

TIMESTAMP(2)

Date and time when statistics for the table or view were lasted updated.

IS_LEVEL2_APPROVED

CHAR(3)

One of:
YES = The table can be used with level 2 DB interface.
NO = The table cannot be used with level 2 DB interface.

IS_PERSISTENT

CHAR(3)

One of:
NO = The table is a temporary table
YES = The table is not temporary.

DATABANK_SYSID

INTEGER

System identifier of the databank in which the table is stored.

LATEST_ROOTID

INTEGER

Identifier for the table used in the rootpage of the databank file.

Primary key: TABLE_SYSID

Secondary index: DATABANK_SYSID

SYSTEM.TABLE_CONSTRAINTS

Records table constraints in the database.

Column name

Data type

Description

TABLE_SYSID

INTEGER

System identifier of the table.

CONSTRAINT_TYPE

CHAR(20)

One of:
PRIMARY KEY
UNIQUE
FOREIGN KEY
INDEX
INDEX UNIQUE
INTERNAL KEY
CHECK.

CONSTRAINT_SYSID

INTEGER

System identifier of the constraint.

CONSTRAINT_KEYCOLS

INTEGER

Number of key columns in the constraint.

CONSTRAINT_KEYLEN

INTEGER

Record length for key columns in the constraint.

CONSTRAINT_RECCOLS

INTEGER

Number of columns in constraint.

CONSTRAINT_RECLEN

INTEGER

Record length for constraint.

CONSTRAINT_CARD

BIGINT

Number of records in constraint.

DATABANK_SYSID

INTEGER

System identifier of the databank in which the table is stored.

IS_CONSISTENT

CHAR(3)

One of:
NO = The index may be inconsistent and should not be used for index lookup only
YES = The index may be used for index lookup only.

IS_DEFERRABLE

CHAR(3)

One of:
NO = The constraint is not deferrable
YES = The constraint is deferrable.

INITIALLY_DEFERRED

CHAR(3)

One of:
NO = The constraint is immediate
YES = The constraint is not immediate.

Primary key: TABLE_SYSID, CONSTRAINT_TYPE, CONSTRAINT_SYSID

Unique constraint: CONSTRAINT_SYSID

SYSTEM.TABLE_PRIVILEGES

Records instances of privileges granted on a table.

Column name

Data type

Description

TABLE_SYSID

INTEGER

System identifier of the table.

PRIVILEGE_TYPE

CHAR(20)

One of:
DELETE
INSERT
LOAD
REFERENCES
SELECT
UPDATE
TRIGGER.

GRANTEE

VARCHAR(128)

The name of the ident to whom the table privilege was granted.

GRANTOR

VARCHAR(128)

The name of the ident granting the table privilege.

IS_GRANTABLE

CHAR(3)

One of:
YES = WITH GRANT OPTION is held with the privilege
NO = WITH GRANT OPTION is not held with the privilege.

IS_INSTEAD_OF

CHAR(3)

One of:
NO = The privilege was granted explicitly
YES = The privilege was granted implicitly when an instead of trigger was created.

IS_ON_TABLE

CHAR(3)

One of:
NO = The privilege was granted on individual columns
YES = The privilege was granted on the complete table.

ALL_COLUMNS

CHAR(3)

One of:
YES = the privilege was granted on the table and therefore applies to all table columns, including new ones added
NO = the privilege only applies to the table columns explicitly specified when the privilege was granted.

Primary key: TABLE_SYSID, PRIVILEGE_TYPE, GRANTEE, GRANTOR

Secondary index: GRANTEE

Secondary index: GRANTOR

SYSTEM.TABLE_TYPES

Records the types of table supported.

Column name

Data type

Description

TABLE_TYPE

CHAR(20)

One of:
SYNONYM
SYSTEM TABLE
TABLE
VIEW.

Primary key: TABLE_TYPE

SYSTEM.TRANSLATIONS

Records character translations in the database.

Column name

Data type

Description

TRANSLATION_SYSID

INTEGER

System identifier of the character set translation.

SRC_CHARSET_SYSID

INTEGER

System identifier of the source character set for the translation.

TGT_CHARSET_SYSID

INTEGER

System identifier of the target character set for the translation.

Primary key: TRANSLATION_SYSID

SYSTEM.TRIGGERED_COLUMNS

Records table columns explicitly specified in an UPDATE TRIGGER event.

Column name

Data type

Description

TRIGGER_SYSID

INTEGER

System identifier of the trigger.

EVENT_TABLE_SYSID

INTEGER

System identifier of the table on which the trigger is defined.

EVENT_COLUMN_NAME

VARCHAR(128)

The name of the column in which updates will cause the trigger to execute.

Primary key: TRIGGER_SYSID, EVENT_TABLE_SYSID, EVENT_COLUMN_NAME

SYSTEM.TRIGGERS

Records triggers in the database.

Column name

Data type

Description

TRIGGER_SYSID

INTEGER

System identifier of the trigger.

EVENT_TABLE_SYSID

INTEGER

System identifier of the table on which the trigger is defined.

EVENT_MANIPULATION

CHAR(20)

One of:
DELETE
INSERT
UPDATE.

ACTION_ORDER

INTEGER

Ordinal number for trigger execution.

This number will define the execution order of triggers on the same table and with the same value for EVENT_MANIPULATION, ACTION_CONDITION, CONDITION_TIMING and ACTION_ORIENTATION.

The trigger with 1 in this column will be executed first, followed by the trigger with 2 etc.

ACTION_CONDITION

NCHAR VARYING(200)

The text of the search condition of the trigger action WHEN clause.

ACTION_STATEMENT

NCHAR VARYING(200)

The character representation of the body of the trigger.

If the length of the text exceeds 200 characters, this value is NULL and the source text is stored in SOURCE_DEFINITION.

ACTION_ORIENTATION

CHAR(20)

One of:
ROW
STATEMENT.

CONDITION_TIMING

CHAR(20)

One of:
BEFORE
AFTER
INSTEAD OF.

COND_REF_NEW_TABLE

VARCHAR(128)

Name of new table/row alias.

COND_REF_OLD_TABLE

VARCHAR(128)

Name of old table/row alias.

REFERENCE_NEW

CHAR(3)

One of:
NO = The trigger has no new table/row alias
YES = The trigger has new table/row alias.

REFERENCE_OLD

CHAR(3)

One of:
NO = The trigger has no new table/row alias
YES = The trigger has new table/row alias.

COLS_IS_IMPLICIT

CHAR(3)

One of:
NO = The trigger is invoked on update on any column (if the event is update)
YES = The trigger will only be invoked if a column in the for update of list is updated.

REF_SYSID

INTEGER

System identifier for foreign key constraint, if the trigger is defined for checking of a delete rule.

Primary key: TRIGGER_SYSID

Secondary index: EVENT_TABLE_SYSID

SYSTEM.TYPE_INFO

Records information about data types supported.

Column name

Data type

Description

DATA_TYPE

SMALLINT

Identification number for data type.

TYPE_NAME

CHAR(30)

Name of data type.

COLUMN_SIZE

INTEGER

Length of data type name.

LITERAL_PREFIX

CHAR(30)

Optional prefix for a literal of this type.

LITERAL_SUFFIX

CHAR(30)

Optional suffix for a literal of this type.

CREATE_PARAMS

CHAR(30)

A description of how to specify length attributes for the data type.

NULLABLE

SMALLINT

One of:
1 = A not null constraint can be used with this type in a domain or column definition
0 = A not null constraint can not be used with this type in a domain or column definition.

CASE_SENSITIVE

SMALLINT

One of:
1 = The data type name is case sensitive
0 = The data type name is not case sensitive.

SEARCHABLE

SMALLINT

One of:
0 = The data type can not be used with any comparison operator
1 = The data type can only be used with the LIKE operator
2 = The data type can be used with any comparison operator except like
3 = The data type can be used with any comparison operator.

UNSIGNED_ATTRIBUTE

SMALLINT

One of:
1 = The data type is unsigned
0 = The data type is signed
The value is NULL if the data type is non-numeric.

FIXED_PREC_SCALE

SMALLINT

One of:
1 = The data type has a determined precision and scale
0 = The data type does not have a determined precision and scale.

AUTO_UNIQUE_VALUE

SMALLINT

One of:
1 = The data type will generate unique values
0 = The data type will not generate unique values.

LOCAL_TYPE_NAME

CHAR(30)

Local name for data type.

MINIMUM_SCALE

SMALLINT

Minimum value for scale for a numeric data type.

MAXIMUM_SCALE

SMALLINT

Maximum value for scale for a numeric data type.

SQL_DATA_TYPE

SMALLINT

A numeric value representing the data type.

SQL_DATETIME_SUB

SMALLINT

Sub type for an interval data type.

NUM_PREC_RADIX

SMALLINT

Radix for numeric data type.

INTERVAL_PRECISION

SMALLINT

Precision for an interval data type.

PRECISION

INTEGER

Precision for data type.

INTERNAL_LEN_DIFF

SMALLINT

Internal length difference.

INTERNAL_TYPENAME

CHAR(30)

Internal type name.

INTERNAL_VERSION

SMALLINT

Internal version number.

INTERNAL_TYPEORDER

SMALLINT

Internal type ordering number.

Primary key: DATA_TYPE, TYPE_NAME

SYSTEM.USAGE_PRIVILEGES

Records instances of privileges which grant the right to use a database object.

Column name

Data type

Description

OBJECT_SYSID

INTEGER

System identifier of the database object.

OBJECT_PRIVILEGE

CHAR(20)

One of:
STRUCTURED
DISTINCT.

GRANTEE

VARCHAR(128)

The name of the ident to whom the usage privilege was granted.

GRANTOR

VARCHAR(128)

The name of the ident granting the usage privilege.

IS_GRANTABLE

CHAR(3)

One of:
YES = WITH GRANT OPTION is held with the privilege
NO = WITH GRANT OPTION is not held with the privilege.

Primary key: OBJECT_SYSID, OBJECT_PRIVILEGE, GRANTEE, GRANTOR

Secondary index: GRANTEE

Secondary index: GRANTOR

SYSTEM.USER_DEF_TYPES

Records user-defined types in the database.

Column name

Data type

Description

UDT_SYSID

INTEGER

System identifier of the user-defined type.

CATEGORY_TYPE

CHAR(20)

One of:
STRUCTURED
DISTINCT.

COLLATION_SYSID

INTEGER

System identifier for the collation used by the column.

CHARSET_SYSID

INTEGER

System identifier for the character set used by the column.

DATA_TYPE

CHAR(30)

Identifies the data type of the column.
Can be one of the following:
BIGINT
BINARY
BINARY VARYING
BINARY LARGE OBJECT
BOOLEAN
CHARACTER
CHARACTER VARYING
CHARACTER LARGE OBJECT
NATIONAL CHARACTER
NATIONAL CHARACTER
VARYING
NATIONAL CHAR LARGE
OBJECT
DATE
DECIMAL
DOUBLE PRECISION
FLOAT
Float(p)
INTEGER
Integer(p)
INTERVAL
NUMERIC
REAL
SMALLINT
TIME
TIMESTAMP.

INTERVAL_TYPE

CHAR(30)

Identifies the interval type of the column

CHAR_MAX_LENGTH

BIGINT

For CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in characters or bytes as appropriate.

For all other data types it is the NULL value.

CHAR_OCTET_LENGTH

BIGINT

For a CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in octets.

For all other data types it is the NULL value. (For single octet character sets, this is the same as CHAR_MAX_LENGTH.)

NUMERIC_PRECISION

INTEGER

For NUMERIC data types, this shows the total number of decimal digits allowed in the column.

For all other data types it is the NULL value. NUMERIC_PREC_RADIX indicates the units of measurement.

NUMERIC_PREC_RADIX

INTEGER

For NUMERIC data types, the value 10 is shown because NUMERIC_PRECISION specifies a number of decimal digits. For all other data types it is the NULL value. NUMERIC_PRECISION and NUMERIC_PREC_RADIX can be combined to calculate the maximum number that the column can hold.

NUMERIC_SCALE

INTEGER

For NUMERIC data types, this shows the total number of significant digits to the right of the decimal point. For INTEGER values this is 0. For all other types, it is the NULL value.

DATETIME_PRECISION

INTEGER

For DATE, TIME, TIMESTAMP and interval data types, this column contains the number of digits of precision for the fractional seconds component.

For other data types it is the NULL value.

INTERVAL_PRECISION

INTEGER

For INTERVAL data types, this is the number of significant digits for the interval leading precision, see the Mimer SQL Reference Manual.

For other data types it is the NULL value.

INTERNAL_LENGTH

INTEGER

Internal length in bytes of value.

IS_INSTANTIABLE

CHAR(3)

(currently not used)

IS_FINAL

CHAR(3)

(currently not used)

ORDERING_FORM

CHAR(20)

(currently not used)

ORDERING_CATEGORY

CHAR(20)

(currently not used)

ORDERING_ROUTINE_SYSID

INTEGER

(currently not used)

NO_OF_ATTRIBUTES

INTEGER

(currently not used)

TOTAL_VLF_LENGTH

INTEGER

(currently not used)

CONSTRUCTOR_FUNCTION

INTEGER

(currently not used)

OBSERVER_METHOD

INTEGER

(currently not used)

TOTAL_DEFAULT_LENGTH

INTEGER

(currently not used)

TOTAL_ATTRIBUTE_NAME_LENGTH

INTEGER

(currently not used)

Primary key: UDT_SYSID

SYSTEM.USERS

Records idents (GROUP, OS_USER, PROGRAM or USER) in the database.

Column name

Data type

Description

USER_NAME

VARCHAR(128)

The ident name.

USER_SYSID

INTEGER

System identifier for the ident.

USER_TYPE

CHAR(20)

One of:
USER
OS_USER
PROGRAM
GROUP.

USER_PASSWORD

BINARY(18)

The encoded password for the ident.

USER_PASSWORD
_MINIMUM_LENGTH

INTEGER

The minimum length for a password.

Primary key: USER_NAME

Unique constraint: USER_SYSID

SYSTEM.VIEWS

Records views in the database.

Column name

Data type

Description

VIEW_SYSID

INTEGER

System identifier of the view.

CHECK_OPTION

CHAR(20)

One of:
CASCADED
LOCAL
NONE.

IS_UPDATABLE

CHAR(3)

One of:
NO = The view can not be updated
YES = The view can be updated.

IS_INSTEAD_OF

CHAR(3)

One of:
NO = The view can be updated per se
YES = The view can be updated due to the existence of an instead of trigger.

VIEW_DEFINITION

NCHAR VARYING(200)

The text of the view definition.

Primary key: VIEW_SYSID

Table name	Description
API_FUNCTION	translation of id to function or module name. See SYSTEM.API_FUNCTION.
AST_CODES	binary representation of the search condition of views in the database (for internal use). See SYSTEM.AST_CODES.
AST_SOURCES	textual representation of view definitions and tables and domains with check constraints. See SYSTEM.AST_SOURCES.
CHAR_SETS	character sets in the database. See SYSTEM.CHAR_SETS.
CHECK_CONSTRAINTS	check constraints defined for tables and domains. See SYSTEM.CHECK_CONSTRAINTS.
COLLATE_DEFS	collation definitions. See SYSTEM.COLLATE_DEFS
COLLATIONS	character collations in the database. See SYSTEM.COLLATIONS.
COLUMN_OBJECT_USE	columns that depend on other database objects. See SYSTEM.COLUMN_OBJECT_USE.
COLUMN_PRIVILEGES	instances of privileges granted on a column. See SYSTEM.COLUMN_PRIVILEGES.
COLUMNS	columns in tables or views. See SYSTEM.COLUMNS.
DATABANKS	databanks in the database. See SYSTEM.DATABANKS.
DOMAIN_CONSTRAINTS	constraints defined for domains. See SYSTEM.DOMAIN_CONSTRAINTS.
DOMAINS	domains in the database. See SYSTEM.DOMAINS.
EXEC_STATEMENTS	precompiled statement. See SYSTEM.FIPS_FEATURES.
FIPS_FEATURES	details about all FIPS features. See SYSTEM.FIPS_FEATURES.
FIPS_SIZING	details about FIPS limits. See SYSTEM.FIPS_SIZING.
KEY_COLUMN_USAGE	columns in an index or in a primary, unique or foreign key. SYSTEM.KEY_COLUMN_USAGE.
LEVEL2_RESTRICT	restrictions for domains legal for use by DB level 2. See SYSTEM.LEVEL2_RESTRICT.
LEVEL2_VIEWCOL	columns of views acceptable by DB level 2. See SYSTEM.LEVEL2_VIEWCOL.
LEVEL2_VIEWRES	restrictions for DB level 2. See SYSTEM.LEVEL2_VIEWRES.
MANYROWS	dummy table with more than one row. See SYSTEM.MANYROWS.
MESSAGE	translation of message code to message text. See SYSTEM.MESSAGE.
MODULES	SQL-server modules in the database. See SYSTEM.MODULES.
OBJECT_COLUMN_USE	columns referenced by other database objects. See SYSTEM.OBJECT_COLUMN_USE.
OBJECT_OBJECT_USE	objects that have a dependency on another object. See SYSTEM.OBJECT_OBJECT_USE.
OBJECTS	objects in the database. See SYSTEM.OBJECTS.
ONEROW	dummy table containing one row. See SYSTEM.ONEROW.
PARAMETERS	parameters of routines in the database. See SYSTEM.PARAMETERS.
REFER_CONSTRAINTS	referential constraints in the database. See SYSTEM.REFER_CONSTRAINTS.
ROUTINES	procedures and user-defined functions in the database. See SYSTEM.ROUTINES.
SCHEMATA	schemas in the database. See SYSTEM.SCHEMATA.
SEQUENCES	sequences in the database. See SYSTEM.SEQUENCES.
SERVER_INFO	attributes of the current database system or server. See SYSTEM.SERVER_INFO.
SEVERITY	severity levels and optional module for error codes. See SYSTEM.SEVERITY.
SOURCE_DEFINITION	source definitions for defaults, check constraints, views, modules, procedures, functions and triggers. See SYSTEM.SOURCE_DEFINITION.
SPECIFIC_NAMES	specific names of the routines in the database. See SYSTEM.SPECIFIC_NAMES.
SQL_CONFORMANCE	SQL functionality. See SYSTEM.SQL_CONFORMANCE.
SQL_LANGUAGES	SQL standards and SQL dialects supported. See SYSTEM.SQL_LANGUAGES.
STATEMENT_DESCRIPTORS	compiled code for statements. See SYSTEM.STATEMENT_DESCRIPTORS.
STATEMENT_ROUTINE_USE	compiled routine used by precompiled statements. See SYSTEM.STATEMENT_ROUTINE_USE.
SYNONYMS	synonyms and shadows in the database. See SYSTEM.SYNONYMS.
TABLE_CONSTRAINTS	table constraints in the database. See SYSTEM.TABLE_CONSTRAINTS.
TABLE_PRIVILEGES	instances of privileges granted on a table. See SYSTEM.TABLE_PRIVILEGES.
TABLE_TYPES	the types of table supported. See SYSTEM.TABLE_TYPES.
TABLES	tables and views in the database. See SYSTEM.TABLES.
TRANSLATIONS	character translations in the database. See SYSTEM.TRANSLATIONS.
TRIGGERED_COLUMNS	table columns explicitly specified in an UPDATE trigger event. See SYSTEM.TRIGGERED_COLUMNS.
TRIGGERS	triggers in the database. See SYSTEM.TRIGGERS.
TYPE_INFO	information about data types supported. See SYSTEM.TYPE_INFO.
USAGE_PRIVILEGES	instances of privileges which grant the right to use a database object. See SYSTEM.USAGE_PRIVILEGES.
USER_DEF_TYPES	user defined types in the database. See SYSTEM.USER_DEF_TYPES.
USERS	idents (GROUP, OS_USER, PROGRAM or USER) in the database. See SYSTEM.USERS.
VIEWS	views in the database. See SYSTEM.VIEWS.

Column name	Data type	Description
MODULEID	INTEGER	System identifier for module.
API_FUNCTION	INTEGER	System identifier for function.
TEXT	CHAR(40)	Name of the function or module.

Column name	Data type	Description
AST_SYSID	INTEGER	System identifier for the view.
AST_VERSION	INTEGER	Current AST-revision version number.
SEQUENCE_NO	INTEGER	Sequence number within representation.
AST_LENGTH	INTEGER	Length of binary data in AST_CODE.
AST_CODE	VARCHAR(1200)	Binary representation of the view search condition.

Column name	Data type	Description
ASTS_SYSID	INTEGER	System identifier for the object which the definition represents.
SEQUENCE_NO	INTEGER	Sequence number within representation.
ASTS_LENGTH	INTEGER	Length of representation.
ASTS_SOURCE	NCHAR VARYING(400)	Textual representation of view, domain or table.

Column name	Data type	Description
CHARSET_SYSID	INTEGER	The system identifier for the character set.
FORM_OF_USE	VARCHAR(128)	A user-defined name that indicates the form-of-use of the character set.
NUMBER_OF_CHARS	INTEGER	Number of characters in the character set.
DEF_COLLATE_SYSID	INTEGER	System identifier for the character collation.

Column name	Data type	Description
CONSTRAINT_SYSID	INTEGER	System identifier for the check constraint.
CHECK_CLAUSE	NCHAR VARYING(200)	The text of the search condition of the check constraint. If the text is too long or NULL value, it will be stored in the SOURCE_DEFINITION table.

Column name	Data type	Description
COLLATION_SYSID	INTEGER	System identifier for the collation.
COLLATION_SEQNO	INTEGER	Sequence number for each row of a definition (starts by 1).
COLLATION_TYPE	INTEGER	Internal identification for the base of the collation.
FROM_COLLATION_SYSID	INTEGER	System identifier for the collation on which this collation is based.
COLLATION_DEF_CHAR_LENGTH	INTEGER	Total length of the collation definition in number of characters.
COLLATION_DEF_CHAR_OFFSET	INTEGER	Offset to where the delta string for this collation starts in the definition.
COLLATION_DEF	NCHAR VARYING(800)	Complete collation definition for this collation (i.e. including the base collation).

Column name	Data type	Description
COLLATION_SYSID	INTEGER	System identifier for the collation.
CHARSET_SYSID	INTEGER	System identifier for the character set.
PAD_ATTRIBUTE	CHAR(20)	One of the following values: NO PAD = the collation has the no pad attribute PAD SPACE = the collation has the pad space attribute.

Column name	Data type	Description
TABLE_SYSID	INTEGER	System identifier for the table or view.
COLUMN_NAME	VARCHAR(128)	The name of the table or view column.
ORDINAL_POSITION	INTEGER	The ordinal position of the column in the table. The first column in the table is number 1.
DOMAIN_SYSID	INTEGER	System identifier for the domain used by the column.
COLLATION_SYSID	INTEGER	System identifier for the collation used by the column.
CHARSET_SYSID	INTEGER	System identifier for the character set used by the column.
UDT_SYSID	INTEGER	System identifier for a user-defined type.
DATA_TYPE	CHAR(30)	Identifies the data type of the column. Can be one of the following: BIGINT BINARY BINARY VARYING BINARY LARGE OBJECT CHARACTER CHARACTER VARYING CHARACTER LARGE OBJECT NATIONAL CHARACTER NATIONAL CHARACTER VARYING NATIONAL CHAR LARGE OBJECT DATE DECIMAL DOUBLE PRECISION FLOAT Float(p) INTEGER Integer(p) INTERVAL NUMERIC REAL SMALLINT TIME TIMESTAMP.
INTERVAL_TYPE	CHAR(30)	For INTERVAL data types, this is a character string specifying the interval qualifier for the named interval data type, see the Mimer SQL Reference Manual. For other data types it is the NULL value.
CHAR_MAX_LENGTH	BIGINT	For CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in characters or bytes as appropriate. For all other data types it is the NULL value.
CHAR_OCTET_LENGTH	BIGINT	For a CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in octets. For all other data types it is the NULL value. (For single octet character sets, this is the same as CHAR_MAX_LENGTH.)
NUMERIC_PRECISION	INTEGER	For NUMERIC data types, this shows the total number of decimal digits allowed in the column. For all other data types it is the NULL value. NUMERIC_PREC_RADIX indicates the units of measurement.
NUMERIC_SCALE	INTEGER	For NUMERIC data types, this shows the total number of significant digits to the right of the decimal point. For INTEGER values this is 0. For all other types, it is the NULL value.
NUMERIC_PREC_RADIX	INTEGER	For NUMERIC data types, the value 10 is shown because NUMERIC_PRECISION specifies a number of decimal digits. For all other data types it is the NULL value. NUMERIC_PRECISION and NUMERIC_PREC_RADIX can be combined to calculate the maximum number that the column can hold.
DATETIME_PRECISION	INTEGER	For DATE, TIME, TIMESTAMP and interval data types, this column contains the number of digits of precision for the fractional seconds component. For other data types it is the NULL value.
INTERVAL_PRECISION	INTEGER	For INTERVAL data types, this is the number of significant digits for the interval leading precision, see the Mimer SQL Reference Manual. For other data types it is the NULL value.
IS_NULLABLE	CHAR(3)	One of: NO = the column is not nullable, according to the rules in the international standard YES = the NULL value is allowed in the column.
IS_UPDATABLE	CHAR(3)	One of: NO = the column is not updatable YES = the column is updatable.
IS_INSTEAD_OF	CHAR(3)	One of: NO YES.
INTERNAL_LENGTH	INTEGER	Internal length in bytes of value.
INTERNAL_OFFSET	INTEGER	Internal offset for value in record.
INTERNAL_VC_OFFSET	INTEGER	Internal offset for field containing actual length for a varying length item.
COLUMN_CARD	BIGINT	Number of unique values in column.
COLUMN_CARD_NONULL	BIGINT	Number of values in column that are not null.
COLUMN_LOW_VALUE	CHAR(16)	Lowest value in column.
COLUMN_HIGH_VALUE	CHAR(16)	Highest value in column.
COLUMN_DEFAULT	NCHAR VARYING(200)	This shows the default value for the column. If the default value is a CHARACTER string, the value shown is the string enclosed in single quotes. If the default value is a NUMERIC LITERAL, the value is shown in its original character representation without enclosing quotes. If the default value is a DATE, TIME or TIMESTAMP, the value shown is the appropriate keyword (e.g. DATE) followed by the literal representation of the value enclosed in single quotes, see the Mimer SQL Reference Manual for a description of DATE, TIME and TIMESTAMP literals). If the default value is a pseudo-literal, the value shown is the appropriate keyword (e.g. CURRENT_DATE) without enclosing quotes. If the default value is the NULL value, the value shown is the keyword NULL without enclosing quotes. If the default value cannot be represented without truncation, then a zero-length string is stored. If no default value was specified then its value is the NULL value. The value of COLUMN_DEF is syntactically suitable for use in specifying default-value in a CREATE TABLE or ALTER TABLE statement.
REMARKS	NCHAR VARYING(254)	A comment on the column. If no comment has been defined a zero length string is stored.

Column name	Data type	Description
OBJECT_TYPE	CHAR(20)	One of: DOMAIN SEQUENCE COLLATION.
OBJECT_SYSID	INTEGER	System identifier for the object on which the column depends.
TABLE_SYSID	INTEGER	System identifier for the table or view.
COLUMN_NAME	VARCHAR(128)	The name of the table or view column.

Column name	Data type	Description
TABLE_SYSID	INTEGER	System identifier for the table or view.
COLUMN_NAME	VARCHAR(128)	The name of the table or view column.
PRIVILEGE_TYPE	CHAR(20)	One of: INSERT REFERENCES SELECT UPDATE.
GRANTEE	VARCHAR(128)	The name of the ident to whom the privilege was granted.
GRANTOR	VARCHAR(128)	The name of the ident granting the privilege.
IS_GRANTABLE	CHAR(3)	One of: NO = WITH GRANT OPTION is not held for the privilege YES = WITH GRANT OPTION is held for the privilege.
IS_INSTEAD_OF	CHAR(3)	One of: NO = The privilege has been granted explicitly YES = The privilege is granted because an instead of trigger has been defined on the view to which the column belongs.

Column name	Data type	Description
DATABANK_SYSID	INTEGER	System identifier for the databank.
DATABANK_SEQNO	INTEGER	The shadowing sequence number for the databank.
DATABANK_FILENO	INTEGER	The file number of the databank file.
DATABANK_NAME	VARCHAR(128)	The name of the databank.
SHADOW_NAME	VARCHAR(128)	The shadow name if the databank is a shadow.
DATABANK_FILENAME	NCHAR VARYING(256)	The path name for the databank file.
DATABANK_TYPE	CHAR(20)	Indicates type of transaction handling: LOG = transaction handling with logging READ ONLY = allows read operations only TEMPORARY = work databank (SQLDB) TRANSACTION = transaction handling without logging WORK = transaction handling not used
IS_MASTER	CHAR(3)	One of: NO = the databank is a shadow YES = the databank is a master.
IS_ONLINE	CHAR(3)	One of: NO = the databank is OFFLINE YES = the databank of ONLINE.
LOBDIR_SYSID	INTEGER	System identifier for the large object directory in the databank.
LOBDATA_SYSID	INTEGER	System identifier for the large object table in the databank
MAXSIZE	BIGINT	Maximum size for databank file, kilo bytes
GOALSIZE	BIGINT	Ideal size for databank file, kilo bytes
MINSIZE	BIGINT	Minimum size for databank file, kilo bytes
IS_REMOVABLE	CHAR(3)	One of: NO = databank is not removable YES = databank is removable
BACKUPED	TIMESTAMP(2)	Last date for backup, currently always set to NULL

Column name	Data type	Description
DOMAIN_SYSID	INTEGER	System identifier for the domain.
CHARSET_SYSID	INTEGER	System identifier for the character set.
COLLATION_SYSID	INTEGER	System identifier for the collation for a domain associated with a character set.
DATA_TYPE	CHAR(30)	Identifies the data type of the domain. Can be one of the following: BIGINT BINARY BINARY VARYING BINARY LARGE OBJECT CHARACTER CHARACTER VARYING CHARACTER LARGE OBJECT NATIONAL CHARACTER NATIONAL CHARACTER VARYING NATIONAL CHAR LARGE OBJECT DATE DECIMAL DOUBLE PRECISION FLOAT Float(p) INTEGER Integer(p) INTERVAL NUMERIC REAL SMALLINT TIME TIMESTAMP.
INTERVAL_TYPE	CHAR(30)	For INTERVAL data types, this is a character string specifying the interval qualifier for the named interval data type, see the Mimer SQL Reference Manual. For other data types it is the NULL value.
CHAR_MAX_LENGTH	BIGINT	For CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in characters or bytes as appropriate. For all other data types it is the NULL value.
CHAR_OCTET_LENGTH	BIGINT	For a CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in octets. For all other data types it is the NULL value. (For single octet character sets, this is the same as CHAR_MAX_LENGTH.)
NUMERIC_PRECISION	INTEGER	For NUMERIC data types, this shows the total number of decimal digits allowed in the column. For all other data types it is the NULL value. NUMERIC_PREC_RADIX indicates the units of measurement.
NUMERIC_SCALE	INTEGER	This defines the total number of significant digits to the right of the decimal point. For INTEGER and SMALLINT, this is 0. For CHARACTER, VARCHAR, DATETIME, FLOAT, INTERVAL, REAL and DOUBLE PRECISION data types, it is the NULL value.
NUMERIC_PREC_RADIX	INTEGER	For NUMERIC data types, the value 10 is shown because NUMERIC_PRECISION specifies a number of decimal digits. For all other data types it is the NULL value. NUMERIC_PRECISION and NUMERIC_PREC_RADIX can be combined to calculate the maximum number that the column can hold.
DATETIME_PRECISION	INTEGER	For DATE, TIME, TIMESTAMP and interval data types, this column contains the number of digits of precision for the fractional seconds component. For other data types it is the NULL value.
INTERVAL_PRECISION	INTEGER	For INTERVAL data types, this is the number of significant digits for the interval leading precision, see the Mimer SQL Reference Manual. For other data types it is the NULL value.
INTERNAL_LENGTH	INTEGER	Internal length in bytes of value.
DOMAIN_DEFAULT	NCHAR VARYING(200)	This shows the default value for the domain. If the default value is a character string, the value shown is the string enclosed in single quotes. If the default value is a numeric literal, the value is shown in its original character representation without enclosing quotes. If the default value is a DATE, TIME or TIMESTAMP, the value shown is the appropriate keyword (e.g. DATE) followed by the literal representation of the value enclosed in single quotes, see Mimer SQL Reference Manual for a description of DATE, TIME and TIMESTAMP literals. If the default value is a pseudo-literal, the value shown is the appropriate keyword (e.g. CURRENT_DATE) without enclosing quotes. If the default value is the NULL value, the value shown is the keyword NULL without enclosing quotes. If the default value cannot be represented without truncation, then a zero-length string is stored. If no default value was specified then its value is the NULL value. The value of DOMAIN_DEFAULT is syntactically suitable for use in specifying default-value in a CREATE TABLE or ALTER TABLE statement.
ANY_CONSTRAINT	CHAR(3)	One of: NO = There are no constraints for the domain YES = There are constraints for the domain.
IS_LEVEL2_APPROVED	CHAR(3)	One of: NO = Tables using this domain can not be used with the level 2 interface YES = The use of this domain does not prohibit the table being used with the level 2 interface.

Column name	Data type	Description
DOMAIN_SYSID	INTEGER	System identifier for the domain.
CONSTRAINT_SYSID	INTEGER	System identifier for the constraint.
IS_DEFERRABLE	CHAR(3)	One of: NO = the constraint is not deferrable. YES = the constraint is deferrable.
INITIALLY_DEFERRED	CHAR(3)	One of: NO = the constraint is not initially deferred YES = the constraint is initially deferred.

Column name	Data type	Description
STATEMENT_SYSID	INTEGER	System identifier for the precompiled statement.
STATEMENT_TYPE	INTEGER	Type of statement (internal value).
STATEMENT_SOURCE	NCHAR VARYING(200)	Source text for the precompiled statement. If the length exceeds 400 characters, this value is NULL and the source text is stored in SOURCE_DEFINITION.
STATEMENT_SOU_LENGTH	CHAR(3)	Length of source text in characters.

Column name	Data type	Description
FEATURE_ID	SMALLINT	Identification number of the FIPS feature.
FEATURE_NAME	CHAR(50)	The name of the FIPS feature.
CLASSIFICATION	CHAR(12)	The conformance level of the feature. One of: TRANSITIONAL INTERMEDIATE FULL.
IS_SUPPORTED	CHAR(3)	One of: YES = Mimer SQL supports the feature NO = Mimer SQL does not support the feature.
IS_VERIFIED	CHAR(3)	One of: YES = Mimer SQL support for the feature has been tested and verified NO = Mimer SQL support for the feature has not been verified.
FEATURE_COMMENTS	VARCHAR(100)	Comments about the feature.

Column name	Data type	Description
SIZING_ID	SMALLINT	Identification number for limit.
DESCRIPTION	CHAR(50)	Description of limit.
ENTRY_VALUE	INTEGER	Limit for entry SQL.
INTERMEDIATE_VALUE	INTEGER	Limit for intermediate SQL.
VALUE_SUPPORTED	INTEGER	Limit for Mimer SQL.
SIZING_COMMENTS	VARCHAR(100)	Comments for limit.

Column name	Data type	Description
TABLE_SYSID	INTEGER	System identifier for the table.
CONSTRAINT_SYSID	INTEGER	System identifier for the table constraint.
ORDINAL_POSITION	INTEGER	The ordinal position of the column in the table. The first column in the table is number 1.
COLUMN_NAME	VARCHAR(128)	The name of the table column.
KEY_TYPE	CHAR(20)	One of: FOREIGN KEY INDEX INTERNAL KEY PRIMARY KEY UNIQUE.
IS_UNIQUE	CHAR(3)	One of: NO = the column may contain non-unique values YES = the column is constrained to contain only unique values.
IS_ASCENDING	CHAR(3)	One of: NO = the column is indexed in descending value order YES = the column is indexed in ascending value order.
COLLATION_SYSID	INTEGER	System identifier for the collation used by the index.

Column name	Data type	Description
DOMAINID	INT(10)	System identifier for the domain with restrictions.
SEQNO	INT(3)	Restriction order number.
LOGOP	CHAR(3)	Logical operator (AND, OR).
RELOP	CHAR(2)	Relational operator (EQ, ...).
LENGTH	INT(5)	Length of the value.
RESVALUE	CHAR(64)	Restriction value.

Column name	Data type	Description
VTABID	INT(10)	View table identifier.
VCOLNO	INT(3)	View table column number.
BTABID	INT(10)	Base table identifier.
BCOLNO	INT(3)	Base table column number.

Column name	Data type	Description
VTABID	INT(10)	View table identifier.
SEQNO	INT(3)	Restriction order number.
LOGOP	CHAR(3)	Logical operator (AND, OR).
BTABID	INT(10)	Base table identifier.
BCOLNO	INT(3)	Base table column number.
RELOP	CHAR(2)	Relational operator (EQ, ...).
LENGTH	INT(5)	Length of the value.
RESVALUE	CHAR(64)	Restriction value.

Column name	Data type	Description
C	INT(3)	The values column.

Column name	Data type	Description
MODULEID	INTEGER	Identification number for Mimer SQL module to which error belongs.
MESSAGEID	INTEGER	Identification number for message
LANGUAGE	INTEGER	Language number for message 1 = English.
LINENO	INTEGER	Line number for message.
MESSAGE	CHAR(80)	Message text.

Column name	Data type	Description
MODULE_SYSID	INTEGER	System identifier for the module.
DEF_CHARSET_SYSID	INTEGER	System identifier for the default character set for the module.
DEF_SCHEMA_SYSID	INTEGER	System identifier for the default schema for the module.
MODULE_LENGTH	INTEGER	Length of the module definition.
MODULE_DEFINITION	NCHAR VARYING(200)	Source text for module definition, if the length of the module definition exceeds 200 characters, this value is NULL and the source text is stored in SOURCE_DEFINITION.
SQL_PATH	VARCHAR(200)	The path for the module.

Column name	Data type	Description
OBJECT_SYSID	INTEGER	System identifier for the database object.
OBJECT_TYPE	VARCHAR(20)	One of: BASE TABLE CHARACTER SET COLLATION CONSTRAINT DATABANK DOMAIN FUNCTION INDEX IDENT MODULE PROCEDURE SCHEMA SEQUENCE SHADOW STATEMENT SYNONYM TRANSLATION TRIGGER VIEW.
OBJECT_SCHEMA	VARCHAR(128)	The name of the schema containing the object.
OBJECT_NAME	VARCHAR(128)	The name of the object.
OBJECT_CREATED	TIMESTAMP(2)	The date and time the object was created.
OBJECT_ALTERED	TIMESTAMP(2)	The date and time the object was last altered.
REMARKS	NCHAR VARYING(254)	Comments defined on the object. If there is no comment defined the empty string ("") will appear. Remarks relating to columns will be stored in the COLUMNS table.

Column name	Data type	Description
TABLE_SYSID	INTEGER	System identifier for the table.
COLUMN_NAME	VARCHAR(128)	The name of the table column.
USED_BY_SYSID	INTEGER	The system identifier of the referencing object.
USED_BY_TYPE	CHAR(20)	One of: VIEW PROCEDURE FUNCTION CHECK TRIGGER STATEMENT.
PRIVILEGE_TYPE	CHAR(20)	One of: INSERT DELETE SELECT UPDATE REFERENCES.

Column name	Data type	Description
OBJECT_SYSID	INTEGER	System identifier for the object used.
OBJECT_TYPE	CHAR(20)	One of: BASE TABLE VIEW PROCEDURE FUNCTION DOMAIN SEQUENCE CHARACTER SET COLLATION TRANSLATION.
USED_BY_SYSID	INTEGER	The system identifier of the referencing object.
USED_BY_TYPE	CHAR(20)	One of: BASE_TABLE VIEW PROCEDURE FUNCTION DOMAIN TRIGGER CHARACTER SET COLLATION TRANSLATION CHECK INDEX STATEMENT.
IS_STRONG	CHAR(3)	One of: NO YES.

Column name	Data type	Description
M	CHAR(1)	Contains the value M.

Column name	Data type	Description
ROUTINE_SYSID	INTEGER	System identifier for the function or procedure.
ORDINAL_POSITION	INTEGER	The ordinal position of the parameter in the routine. The first parameter in the routine is number 1.
IS_RESULT	CHAR(3)	One of: NO = This parameter is not part of the result clause for a result set procedure YES = This parameter is part of the result set.
PARAMETER_MODE	CHAR(5)	One of: IN OUT INOUT.
PARAMETER_NAME	VARCHAR(128)	The name of the parameter.
DOMAIN_SYSID	INTEGER	System identifier of the domain that defines the data type of the parameter.
COLLATION_SYSID	INTEGER	System identifier of the collation associated with the parameter.
CHARSET_SYSID	INTEGER	The system identifier for the character set.
UDT_SYSID	INTEGER	System identifier for a user-defined type.
DATA_TYPE	CHAR(30)	The data type of the parameter.
INTERVAL_TYPE	CHAR(30)	For INTERVAL data types, this is a character string specifying the interval qualifier for the named interval data type, see the Mimer SQL Reference Manual. For other data types it is the NULL value.
CHAR_MAX_LENGTH	BIGINT	For CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in characters or bytes as appropriate. For all other data types it is the NULL value.
CHAR_OCTET_LENGTH	BIGINT	For a CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in octets. For all other data types it is the NULL value. (For single octet character sets, this is the same as CHAR_MAX_LENGTH.)
NUMERIC_PRECISION	INTEGER	For NUMERIC data types, this shows the total number of decimal digits allowed in the column. For all other data types it is the NULL value. NUMERIC_PREC_RADIX indicates the units of measurement.
NUMERIC_SCALE	INTEGER	This defines the total number of significant digits to the right of the decimal point. For INTEGER and SMALLINT, this is 0. For CHARACTER, VARCHAR, DATETIME, FLOAT, INTERVAL, REAL and DOUBLE PRECISION data types, it is the NULL value.
NUMERIC_PREC_RADIX	INTEGER	For numeric data types, the value 10 is shown because NUMERIC_PRECISION specifies a number of decimal digits. For all other data types it is the NULL value. NUMERIC_PRECISION and NUMERIC_PREC_RADIX can be combined to calculate the maximum number that the column can hold.
DATETIME_PRECISION	INTEGER	For DATE, TIME, TIMESTAMP and INTERVAL data types, this column contains the number of digits of precision for the fractional seconds component. For other data types it is the NULL value.
INTERVAL_PRECISION	INTEGER	For INTERVAL data types, this is the number of significant digits for the interval leading precision, see the Mimer SQL Reference Manual. For other data types it is the NULL value.

Column name	Data type	Description
TABLE_SYSID	INTEGER	System identifier for the table.
CONSTRAINT_SYSID	INTEGER	System identifier for the referential constraint.
UNIQUE_TABLE_SYSID	INTEGER	System identifier for the table that is referenced in the foreign key.
UNIQUE_CONST_SYSID	INTEGER	System identifier for the constraint that is (implicitly) referenced in the foreign key.
MATCH_OPTION	CHAR(20)	One of: NONE PARTIAL FULL.
UPDATE_RULE	CHAR(20)	One of: CASCADE SET NULL SET DEFAULT NO ACTION RESTRICT.
DELETE_RULE	CHAR(20)	One of: CASCADE SET NULL SET DEFAULT NO ACTION RESTRICT.

Column name	Data type	Description
ROUTINE_SYSID	INTEGER	System identifier of the function or procedure.
MODULE_SYSID	INTEGER	System identifier of the module to which the routine belongs.
ROUTINE_TYPE	CHAR(20)	One of: PROCEDURE FUNCTION.
SQL_DATA_ACCESS	CHAR(20)	One of: NO SQL CONTAINS SQL READS SQL DATA MODIFIES SQL DATA.
ROUTINE_OFFSET	INTEGER	Offset for routine within module definition. This value is zero if the routine ins not defined in a module.
ROUTINE_LENGTH	INTEGER	Length of routine definition
TOTAL_PARAMS	INTEGER	The total number of routine parameters.
RESULT_PARAMS	INTEGER	The number of result parameters.
INPUT_PARAMS	INTEGER	The number of input parameters.
OUTPUT_PARAMS	INTEGER	The number of output parameters.
ROUTINE_DEFINITION	NCHAR VARYING(200)	Routine definition. If the length of the routine definition exceeds 400 characters, this value is NULL and the source text is stored in SOURCE_DEFINITION.
SQL_PATH	VARCHAR(200)	The search path for the routine.
IS_DETERMINISTIC	CHAR(3)	One of: NO = The routine is not deterministic. i.e. invoking the routine with the same input values is not guaranteed to return the same result YES = The routine is deterministic, i.e. when invoked with same input values it will always return the same result.
ROUTINE_BODY	CHAR(20)	One of: SQL = The routine is an SQL routine EXTERNAL = The routine is external
EXTERNAL_NAME	VARCHAR(128)	The name of the program that implements the routine if it is an external routine otherwise null.
EXTERNAL_LANGUAGE	CHAR(20)	The language for the routine if it is external otherwise null.
PARAMETER_STYLE	CHAR(20)	The parameter passing style for the routine if it is an external routine, otherwise null.
SCHEMA_LEVEL_ROU	CHAR(3)	One of: NO = The routine is defined within a module YES = The routine is not defined in a module.
MX_DYN_RESULT_SETS	INTEGER	The maximal number of result sets that the routine may return.
UDT_SYSID	INTEGER	(currently not used)
IS_USER_DEFINED_CAST	CHAR(3)	(currently not used)
IS_IMPLICITLY_INVOCABLE	CHAR(3)	(currently not used)
MS_SYSID	INT	(currently not used)

Column name	Data type	Description
SCHEMA_SYSID	INTEGER	System identifier of the schema.
DEF_CHARSET_SYSID	INTEGER	System identifier of the default character set.
SQL_PATH	VARCHAR(200)	The default search path for objects belonging to the schema.

Column name	Data type	Description
SEQUENCE_SYSID	INTEGER	System identifier of the sequence.
DATA_TYPE	CHAR(30)	One of: SMALLINT INTEGER BIGINT.
NUMERIC_PRECISION	INTEGER	Precision for data type.
MAXIMUM_VALUE	BIGINT	The maximum value of the sequence.
MINIMUM_VALUE	BIGINT	The minimum value of the sequence.
INCREMENT	BIGINT	The increment value for sequence.
CYCLE_OPTION	CHAR(3)	One of: 'YES ' = the sequence will restart when all values are exhausted 'NO ' = the sequence will not restart when all values are exhausted.
START_VALUE	BIGINT	Start value for sequence when first used.
CURRENT_VALUE	BIGINT	Start value at system start up.
IS_EXHAUSTED	CHAR(3)	One of: YES = the series of values defined by the sequence is exhausted NO = the series of values defined by the sequence is not exhausted.
CYCLES	BIGINT	Number of times the maximum value of the sequence is exceeded.
DATABANK_SYSID	INTEGER	Databank location.

Column name	Data type	Description
SERVER_ATTRIBUTE	VARCHAR(254)	One of: AUTOUPGRADE_ENABLED CATALOG_NAME COLLATION_SEQ CURRENT_COLLATION_ID IDENTIFIER_LENGTH INTERVAL_FRAC_PREC INTERVAL_LEAD_PREC ROW_LENGTH TIME_PREC TIMESTAMP_PREC TXN_ISOLATION USERID_LENGTH CATALOG_VERSION_CREATED CATALOG_VERSION_CURRENT.
ATTRIBUTE_VALUE	VARCHAR(254)	The value for the attribute.

Column name	Data type	Description
MODULEID	INTEGER	Identification number for the Mimer SQL module to which the message belongs.
MESSAGEID	INTEGER	Identification number for message.
SEVERITY	INTEGER	Severity for message: 1 = Message 2 = Warning 3 = Error 4 = Fatal error 5 = Internal error 6 = Code.
MODULE	CHAR(20)	Name of Mimer SQL module to which the message belongs.
SQLSTATE_VALUE	CHAR(5)	Corresponding SQLSTATE value for message.
CLASS_ORIGIN	CHAR(20)	Class origin for the SQLSTATE value.
SUBCLASS_ORIGIN	CHAR(20)	Sub class origin for the SQLSTATE value.

Column name	Data type	Description
SOURCE_SYSID	INTEGER	System identifier of the source definition.
COLUMN_NAME	VARCHAR(128)	Column name if the source types is a default value for a column.
SOURCE_TYPE	CHAR(20)	One of: DEFAULT CHECK VIEW ROUTINE STATEMENT.
SEQUENCE_NO	INTEGER	Sequence number in source definition.
SOURCE_LENGTH	INTEGER	The length of the stored source text.
SOURCE_DEFINITION	NCHAR VARYING(400)	The stored source text.

Column name	Data type	Description
ROUTINE_SYSID	INTEGER	System identifier of the routine.
SPECIFIC_SCHEMA	VARCHAR(128)	The name of the schema containing the routine.
SPECIFIC_NAME	VARCHAR(128)	The specific name for the routine.
UDT_SYSID	INTEGER	(currently not used)

Column name	Data type	Description
CONFORMANCE_ID	CHAR(20)	Identification of the conformance element described.
CONFORMANCE_SUB_ID	CHAR(20)	If the conformance element is a subfeature then it's identification, otherwise a single space.
CONFORMANCE_TYPE	CHAR(20)	Type of conformance element. FEATURE, SUBFEATURE, PACKAGE, or PART.
CONFORMANCE_IS_CORE_SQL	CHAR(3)	YES if the conformance element belongs to Core SQL, otherwise NO.
CONFORMANCE_NAME	VARCHAR(100)	Short description of the conformance element.
CONFORMANCE_SUB_NAME	VARCHAR(100)	Short description of a subfeature, otherwise a single space.
CONFORMANCE_IS_SUPPORTED	CHAR(3)	YES if fully supported by Mimer SQL, otherwise NO.
CONFORMANCE_IS_VERIFIED_BY	CHAR(3)	Should identify conformance test used to verify the conformance (always NULL).
CONFORMANCE_REMARKS	VARCHAR(100)	Comments pertinent to the conformance element.

Column name	Data type	Description
SOURCE	VARCHAR(100)	Body that has defined standard.
SOURCE_YEAR	VARCHAR(100)	Which year the standard was approved.
CONFORMANCE	VARCHAR(100)	Level of conformance within standard.
INTEGRITY	VARCHAR(100)	If the supported standard is ISO 9075 the value YES in this column means that the integrity enhancement feature of this standard is supported, otherwise the value of this column is null.
IMPLEMENTATION	VARCHAR(100)	Implementation style, always null in Mimer SQL.
BINDING_STYLE	VARCHAR(100)	One of: DIRECT = Support for interactive (ad hoc) access to the database EMBEDDED = Support for access through an application programming interface.
PROGRAMMING_LANG	VARCHAR(100)	Name of programming languages that are supported if the binding style is EMBEDDED.
ORDINAL_NO	INTEGER	Ordinal number.

Column name	Data type	Description
STATEMENT_SYSID	INTEGER	System identifier for the precompiled statement.
DESC_MODE	INTEGER	Mode, one of: 1 = no scroll 2 = scroll
DESC_TYPE	INTEGER	Internal. Naming or section descriptor type.
DESC_SEQNO	INTEGER	Sequence number for compiled code.
DESC_CODE_LENGTH	INTEGER	Length of compiled code.
DESC_CODE	BINARY(1000)	Compiled code.
DESC_VERSION	INTEGER	Compiler version used.

Column name	Data type	Description
STATEMENT_SYSID	INTEGER	System identifier for the precompiled statement.
USE_SEQNO	INTEGER	Sequence number.
USE_LEVEL	INTEGER	Call level for routine.
USE_ROUTINE_SYSID	INTEGER	System identifier for called routines.

Column name	Data type	Description
SYNONYM_SYSID	INTEGER	System identifier of the synonym.
ORDINARY_SYSID	INTEGER	System identifier of the original object.

Column name	Data type	Description
TABLE_SYSID	INTEGER	System identifier of the table or view.
TABLE_TYPE	CHAR(20)	One of: BASE TABLE VIEW.
TABLE_NOCOLS	INTEGER	Number of columns in table.
TABLE_RECLEN	INTEGER	Record length for table.
TABLE_CARD	BIGINT	Number of records in table.
STATISTIC_GATHERED	TIMESTAMP(2)	Date and time when statistics for the table or view were lasted updated.
IS_LEVEL2_APPROVED	CHAR(3)	One of: YES = The table can be used with level 2 DB interface. NO = The table cannot be used with level 2 DB interface.
IS_PERSISTENT	CHAR(3)	One of: NO = The table is a temporary table YES = The table is not temporary.
DATABANK_SYSID	INTEGER	System identifier of the databank in which the table is stored.
LATEST_ROOTID	INTEGER	Identifier for the table used in the rootpage of the databank file.

Column name	Data type	Description
TABLE_SYSID	INTEGER	System identifier of the table.
CONSTRAINT_TYPE	CHAR(20)	One of: PRIMARY KEY UNIQUE FOREIGN KEY INDEX INDEX UNIQUE INTERNAL KEY CHECK.
CONSTRAINT_SYSID	INTEGER	System identifier of the constraint.
CONSTRAINT_KEYCOLS	INTEGER	Number of key columns in the constraint.
CONSTRAINT_KEYLEN	INTEGER	Record length for key columns in the constraint.
CONSTRAINT_RECCOLS	INTEGER	Number of columns in constraint.
CONSTRAINT_RECLEN	INTEGER	Record length for constraint.
CONSTRAINT_CARD	BIGINT	Number of records in constraint.
DATABANK_SYSID	INTEGER	System identifier of the databank in which the table is stored.
IS_CONSISTENT	CHAR(3)	One of: NO = The index may be inconsistent and should not be used for index lookup only YES = The index may be used for index lookup only.
IS_DEFERRABLE	CHAR(3)	One of: NO = The constraint is not deferrable YES = The constraint is deferrable.
INITIALLY_DEFERRED	CHAR(3)	One of: NO = The constraint is immediate YES = The constraint is not immediate.

Column name	Data type	Description
TABLE_SYSID	INTEGER	System identifier of the table.
PRIVILEGE_TYPE	CHAR(20)	One of: DELETE INSERT LOAD REFERENCES SELECT UPDATE TRIGGER.
GRANTEE	VARCHAR(128)	The name of the ident to whom the table privilege was granted.
GRANTOR	VARCHAR(128)	The name of the ident granting the table privilege.
IS_GRANTABLE	CHAR(3)	One of: YES = WITH GRANT OPTION is held with the privilege NO = WITH GRANT OPTION is not held with the privilege.
IS_INSTEAD_OF	CHAR(3)	One of: NO = The privilege was granted explicitly YES = The privilege was granted implicitly when an instead of trigger was created.
IS_ON_TABLE	CHAR(3)	One of: NO = The privilege was granted on individual columns YES = The privilege was granted on the complete table.
ALL_COLUMNS	CHAR(3)	One of: YES = the privilege was granted on the table and therefore applies to all table columns, including new ones added NO = the privilege only applies to the table columns explicitly specified when the privilege was granted.

Column name	Data type	Description
TABLE_TYPE	CHAR(20)	One of: SYNONYM SYSTEM TABLE TABLE VIEW.

Column name	Data type	Description
TRANSLATION_SYSID	INTEGER	System identifier of the character set translation.
SRC_CHARSET_SYSID	INTEGER	System identifier of the source character set for the translation.
TGT_CHARSET_SYSID	INTEGER	System identifier of the target character set for the translation.

Column name	Data type	Description
TRIGGER_SYSID	INTEGER	System identifier of the trigger.
EVENT_TABLE_SYSID	INTEGER	System identifier of the table on which the trigger is defined.
EVENT_COLUMN_NAME	VARCHAR(128)	The name of the column in which updates will cause the trigger to execute.

Column name	Data type	Description
TRIGGER_SYSID	INTEGER	System identifier of the trigger.
EVENT_TABLE_SYSID	INTEGER	System identifier of the table on which the trigger is defined.
EVENT_MANIPULATION	CHAR(20)	One of: DELETE INSERT UPDATE.
ACTION_ORDER	INTEGER	Ordinal number for trigger execution. This number will define the execution order of triggers on the same table and with the same value for EVENT_MANIPULATION, ACTION_CONDITION, CONDITION_TIMING and ACTION_ORIENTATION. The trigger with 1 in this column will be executed first, followed by the trigger with 2 etc.
ACTION_CONDITION	NCHAR VARYING(200)	The text of the search condition of the trigger action WHEN clause.
ACTION_STATEMENT	NCHAR VARYING(200)	The character representation of the body of the trigger. If the length of the text exceeds 200 characters, this value is NULL and the source text is stored in SOURCE_DEFINITION.
ACTION_ORIENTATION	CHAR(20)	One of: ROW STATEMENT.
CONDITION_TIMING	CHAR(20)	One of: BEFORE AFTER INSTEAD OF.
COND_REF_NEW_TABLE	VARCHAR(128)	Name of new table/row alias.
COND_REF_OLD_TABLE	VARCHAR(128)	Name of old table/row alias.
REFERENCE_NEW	CHAR(3)	One of: NO = The trigger has no new table/row alias YES = The trigger has new table/row alias.
REFERENCE_OLD	CHAR(3)	One of: NO = The trigger has no new table/row alias YES = The trigger has new table/row alias.
COLS_IS_IMPLICIT	CHAR(3)	One of: NO = The trigger is invoked on update on any column (if the event is update) YES = The trigger will only be invoked if a column in the for update of list is updated.
REF_SYSID	INTEGER	System identifier for foreign key constraint, if the trigger is defined for checking of a delete rule.

Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se

Column name	Data type	Description
DATA_TYPE	SMALLINT	Identification number for data type.
TYPE_NAME	CHAR(30)	Name of data type.
COLUMN_SIZE	INTEGER	Length of data type name.
LITERAL_PREFIX	CHAR(30)	Optional prefix for a literal of this type.
LITERAL_SUFFIX	CHAR(30)	Optional suffix for a literal of this type.
CREATE_PARAMS	CHAR(30)	A description of how to specify length attributes for the data type.
NULLABLE	SMALLINT	One of: 1 = A not null constraint can be used with this type in a domain or column definition 0 = A not null constraint can not be used with this type in a domain or column definition.
CASE_SENSITIVE	SMALLINT	One of: 1 = The data type name is case sensitive 0 = The data type name is not case sensitive.
SEARCHABLE	SMALLINT	One of: 0 = The data type can not be used with any comparison operator 1 = The data type can only be used with the LIKE operator 2 = The data type can be used with any comparison operator except like 3 = The data type can be used with any comparison operator.
UNSIGNED_ATTRIBUTE	SMALLINT	One of: 1 = The data type is unsigned 0 = The data type is signed The value is NULL if the data type is non-numeric.
FIXED_PREC_SCALE	SMALLINT	One of: 1 = The data type has a determined precision and scale 0 = The data type does not have a determined precision and scale.
AUTO_UNIQUE_VALUE	SMALLINT	One of: 1 = The data type will generate unique values 0 = The data type will not generate unique values.
LOCAL_TYPE_NAME	CHAR(30)	Local name for data type.
MINIMUM_SCALE	SMALLINT	Minimum value for scale for a numeric data type.
MAXIMUM_SCALE	SMALLINT	Maximum value for scale for a numeric data type.
SQL_DATA_TYPE	SMALLINT	A numeric value representing the data type.
SQL_DATETIME_SUB	SMALLINT	Sub type for an interval data type.
NUM_PREC_RADIX	SMALLINT	Radix for numeric data type.
INTERVAL_PRECISION	SMALLINT	Precision for an interval data type.
PRECISION	INTEGER	Precision for data type.
INTERNAL_LEN_DIFF	SMALLINT	Internal length difference.
INTERNAL_TYPENAME	CHAR(30)	Internal type name.
INTERNAL_VERSION	SMALLINT	Internal version number.
INTERNAL_TYPEORDER	SMALLINT	Internal type ordering number.

Column name	Data type	Description
OBJECT_SYSID	INTEGER	System identifier of the database object.
OBJECT_PRIVILEGE	CHAR(20)	One of: STRUCTURED DISTINCT.
GRANTEE	VARCHAR(128)	The name of the ident to whom the usage privilege was granted.
GRANTOR	VARCHAR(128)	The name of the ident granting the usage privilege.
IS_GRANTABLE	CHAR(3)	One of: YES = WITH GRANT OPTION is held with the privilege NO = WITH GRANT OPTION is not held with the privilege.

Column name	Data type	Description
UDT_SYSID	INTEGER	System identifier of the user-defined type.
CATEGORY_TYPE	CHAR(20)	One of: STRUCTURED DISTINCT.
COLLATION_SYSID	INTEGER	System identifier for the collation used by the column.
CHARSET_SYSID	INTEGER	System identifier for the character set used by the column.
DATA_TYPE	CHAR(30)	Identifies the data type of the column. Can be one of the following: BIGINT BINARY BINARY VARYING BINARY LARGE OBJECT BOOLEAN CHARACTER CHARACTER VARYING CHARACTER LARGE OBJECT NATIONAL CHARACTER NATIONAL CHARACTER VARYING NATIONAL CHAR LARGE OBJECT DATE DECIMAL DOUBLE PRECISION FLOAT Float(p) INTEGER Integer(p) INTERVAL NUMERIC REAL SMALLINT TIME TIMESTAMP.
INTERVAL_TYPE	CHAR(30)	Identifies the interval type of the column
CHAR_MAX_LENGTH	BIGINT	For CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in characters or bytes as appropriate. For all other data types it is the NULL value.
CHAR_OCTET_LENGTH	BIGINT	For a CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in octets. For all other data types it is the NULL value. (For single octet character sets, this is the same as CHAR_MAX_LENGTH.)
NUMERIC_PRECISION	INTEGER	For NUMERIC data types, this shows the total number of decimal digits allowed in the column. For all other data types it is the NULL value. NUMERIC_PREC_RADIX indicates the units of measurement.
NUMERIC_PREC_RADIX	INTEGER	For NUMERIC data types, the value 10 is shown because NUMERIC_PRECISION specifies a number of decimal digits. For all other data types it is the NULL value. NUMERIC_PRECISION and NUMERIC_PREC_RADIX can be combined to calculate the maximum number that the column can hold.
NUMERIC_SCALE	INTEGER	For NUMERIC data types, this shows the total number of significant digits to the right of the decimal point. For INTEGER values this is 0. For all other types, it is the NULL value.
DATETIME_PRECISION	INTEGER	For DATE, TIME, TIMESTAMP and interval data types, this column contains the number of digits of precision for the fractional seconds component. For other data types it is the NULL value.
INTERVAL_PRECISION	INTEGER	For INTERVAL data types, this is the number of significant digits for the interval leading precision, see the Mimer SQL Reference Manual. For other data types it is the NULL value.
INTERNAL_LENGTH	INTEGER	Internal length in bytes of value.
IS_INSTANTIABLE	CHAR(3)	(currently not used)
IS_FINAL	CHAR(3)	(currently not used)
ORDERING_FORM	CHAR(20)	(currently not used)
ORDERING_CATEGORY	CHAR(20)	(currently not used)
ORDERING_ROUTINE_SYSID	INTEGER	(currently not used)
NO_OF_ATTRIBUTES	INTEGER	(currently not used)
TOTAL_VLF_LENGTH	INTEGER	(currently not used)
CONSTRUCTOR_FUNCTION	INTEGER	(currently not used)
OBSERVER_METHOD	INTEGER	(currently not used)
TOTAL_DEFAULT_LENGTH	INTEGER	(currently not used)
TOTAL_ATTRIBUTE_NAME_LENGTH	INTEGER	(currently not used)

Column name	Data type	Description
USER_NAME	VARCHAR(128)	The ident name.
USER_SYSID	INTEGER	System identifier for the ident.
USER_TYPE	CHAR(20)	One of: USER OS_USER PROGRAM GROUP.
USER_PASSWORD	BINARY(18)	The encoded password for the ident.
USER_PASSWORD _MINIMUM_LENGTH	INTEGER	The minimum length for a password.

Column name	Data type	Description
VIEW_SYSID	INTEGER	System identifier of the view.
CHECK_OPTION	CHAR(20)	One of: CASCADED LOCAL NONE.
IS_UPDATABLE	CHAR(3)	One of: NO = The view can not be updated YES = The view can be updated.
IS_INSTEAD_OF	CHAR(3)	One of: NO = The view can be updated per se YES = The view can be updated due to the existence of an instead of trigger.
VIEW_DEFINITION	NCHAR VARYING(200)	The text of the view definition.