Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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(2400)

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(800)

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(400)

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(400)

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

VARCHAR(256)

The path name for the databank file.

DATABANK_TYPE

CHAR(20)

Indicates type of transaction handling:
LOG = transaction handling with logging
TRANS = transaction handling without logging
NULL = transaction handling not used
WORK = work databank (SQLDB).

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.

Primary key: DATABANK_SYSID, DATABANK_SEQNO, DATABANK_FILENO

Unique constraint: SHADOW_NAME, DATABANK_FILENO

Unique constraint: DATABANK_FILENAME

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(400)

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(400)

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(500)

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(500)

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(400)

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

SQL_PATH

VARCHAR(1000)

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

CHAR(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.

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(400)

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(1000)

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 a 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.

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(1000)

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.

IS_UNIQUE

CHAR(3)

One of:
YES = the sequence will yield unique values
NO = the sequence may repeat itself.

START_VALUE

INTEGER

The initial value of the sequence.

CURRENT_VALUE

INTEGER

The current value of the sequence.

MAX_VALUE

INTEGER

The maximum value of the sequence.

INCREMENT_VALUE

INTEGER

The increment value of sequence.

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

INTEGER

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

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:
CATALOG_NAME
COLLATION_SEQ
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(800)

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.

Primary key: ROUTINE_SYSID

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(254)

Short description of the conformance element.

CONFORMANCE_SUB_NAME

VARCHAR(254)

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(254)

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(254)

Body that has defined standard.

SOURCE_YEAR

VARCHAR(254)

Which year the standard was approved.

CONFORMANCE

VARCHAR(254)

Level of conformance within standard.

INTEGRITY

VARCHAR(254)

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(254)

Implementation style, always null in Mimer SQL.

BINDING_STYLE

VARCHAR(254)

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

PROGRAMMING_LANG

VARCHAR(254)

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.

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(400)

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

ACTION_STATEMENT

NCHAR VARYING(400)

The character representation of the body of the trigger.
If the length of the text exceeds 400 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)

Contains STRUCTURED or 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)

Contains STRUCTURED or 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
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.

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.

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(400)

The text of the view definition.

Primary key: VIEW_SYSID


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX