Data Dictionary Tables

This appendix documents the organization of the data dictionary tables, which are stored in the databank SYSDB.

The tables are created by the SDBGEN program when the system is created. The tables are created in a schema called SYSTEM and are thus effectively owned by a pseudo ident called SYSTEM.

The database administration ident SYSADM is granted SELECT access on the dictionary tables with the WITH GRANT OPTION. No other user may read the data dictionary base tables unless authorized to do so by SYSADM.

A set of system views is defined on the data dictionary tables when the system is installed, see the Mimer SQL Reference Manual, Data Dictionary Views for more information).

The logical group PUBLIC is granted SELECT access on these views, so that any user may read the dictionary information presented in the views. Many of the view definitions restrict the information presented to descriptions of objects and privileges accessible to the current user.

Note:If SYSADM reads the contents of such a view, the result shows only the objects and privileges to which SYSADM has access. In order to gain information on inaccessible objects and privileges, SYSADM must read the contents of the dictionary base tables directly.

The SYSADM ident may define installation-specific views on the data dictionary tables to supplement the system-defined views. Such views may be tailor-made for the installation or system in use, and SELECT access on the views may be granted to limited user groups if desired.

All maintenance of the data dictionary is performed by internal routines and is invisible to the user. No user, including SYSADM, may alter the contents of the data dictionary directly.

Note:Mimer reserves the right to change the internal organization of the data dictionary, without maintaining backward compatibility with user-written application programs which read the data dictionary tables directly.

Summary of Data Dictionary Tables

Table name	Description
SYSTEM.API_FUNCTION	Translation of id to function or module name.
SYSTEM.AST_CODES	Binary representation of the search condition of views in the database (for internal use).
SYSTEM.AST_SOURCES	Textual representation of view definitions and tables and domains with check constraints.
SYSTEM.ATTRIBUTES	Attributes of user-defined types.
SYSTEM.CHAR_SETS	Character sets in the database.
SYSTEM.CHECK_CONSTRAINTS	Check constraints defined for tables and domains.
SYSTEM.COLLATE_DEFS	Collation definitions.
SYSTEM.COLLATIONS	Character collations in the database.
SYSTEM.COLUMN_OBJECT_USE	Columns that depend on other database objects.
SYSTEM.COLUMN_PRIVILEGES	Instances of privileges granted on a column.
SYSTEM.COLUMNS	Columns in tables or views.
SYSTEM.COMMENTS	Comments on objects.
SYSTEM.DATABANKS	Databanks in the database.
SYSTEM.DIRECT_SUPERTYPES	Direct supertypes in the database.
SYSTEM.DOMAIN_CONSTRAINTS	Constraints defined for domains.
SYSTEM.DOMAINS	Domains in the database.
SYSTEM.EXEC_STATEMENTS	Precompiled statements.
SYSTEM.FIPS_FEATURES	Details about all FIPS features.
SYSTEM.FIPS_SIZING	Details about FIPS limits.
SYSTEM.HEURISTICS	Details about heuristics.
SYSTEM.KEY_COLUMN_USAGE	Columns in an index or in a primary, unique or foreign key.
SYSTEM.LEVEL2_RESTRICT	Restrictions for domains legal for use by DB level 2.
SYSTEM.LEVEL2_VIEWCOL	Columns of views acceptable by DB level 2.
SYSTEM.LEVEL2_VIEWRES	Restrictions for DB level 2.
SYSTEM.LIBRARIES	External libraries.
SYSTEM.LOGINS	OS_USER logins for user idents.
SYSTEM.MANYROWS	Dummy table with more than one row.
SYSTEM.MESSAGE	Translation of message code to message text.
SYSTEM.METHOD_SPECIFICATION_PARAMETERS	Method specification parameters.
SYSTEM.METHOD_SPECIFICATIONS	Method specifications.
SYSTEM.MODULES	SQL-server modules in the database.
SYSTEM.NANO_DATABANKS	(Currently not used.)
SYSTEM.NANO_DESCRIPTORS	(Currently not used.)
SYSTEM.NANO_OBJECTS	(Currently not used.)
SYSTEM.NANO_ROUTINE_USE	(Currently not used.)
SYSTEM.NANO_USERS	(Currently not used.)
SYSTEM.OBJECT_COLUMN_USE	Columns referenced by other database objects.
SYSTEM.OBJECT_OBJECT_USE	Objects that have a dependency on another object.
SYSTEM.OBJECT_PROGRAMS	Information about predefined executable statements for table operations and routines.
SYSTEM.OBJECTS	Objects in the database.
SYSTEM.ONEROW	Dummy table containing one row.
SYSTEM.PARAMETERS	Parameters of routines in the database.
SYSTEM.REFER_CONSTRAINTS	Referential constraints in the database.
SYSTEM.ROUTINES	Procedures and user-defined functions in the database.
SYSTEM.SCHEMATA	Schemas in the database.
SYSTEM.SEQUENCE_VALUE_TABLE	Current values of sequences.
SYSTEM.SEQUENCES	Sequences in the database.
SYSTEM.SERVER_INFO	Attributes of the current database system or server.
SYSTEM.SEVERITY	Severity levels and optional module for error codes.
SYSTEM.SOURCE_DEFINITION	Source definitions for defaults, check constraints, views, modules, procedures, functions and triggers.
SYSTEM.SPECIFIC_NAMES	Specific names of the routines in the database.
SYSTEM.SQL_CONFORMANCE	SQL functionality.
SYSTEM.SQL_LANGUAGES	SQL standards and SQL dialects supported.
SYSTEM.STATEMENT_DESCRIPTORS	Compiled code for statements.
SYSTEM.STATEMENT_ROUTINE_USE	Compiled routine used by precompiled statements.
SYSTEM.SYNONYMS	Synonyms and shadows in the database.
SYSTEM.TABLE_CONSTRAINTS	Table constraints in the database.
SYSTEM.TABLE_PRIVILEGES	Instances of privileges granted on a table.
SYSTEM.TABLE_TYPES	The types of table supported.
SYSTEM.TABLES	Tables and views in the database.
SYSTEM.TRANSLATIONS	Character translations in the database.
SYSTEM.TRIGGERED_COLUMNS	Table columns explicitly specified in an UPDATE trigger event.
SYSTEM.TRIGGERS	Triggers in the database.
SYSTEM.TYPE_INFO	Information about data types supported.
SYSTEM.USAGE_PRIVILEGES	Instances of privileges which grant the right to use a database object.
SYSTEM.USER_DEF_TYPES	User-defined types in the database.
SYSTEM.USERS	Idents (GROUP, PROGRAM or USER) in the database.
SYSTEM.VIEWS	Views in the database.

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.
STRUCT_VERSION	INTEGER	Compiler 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, STRUCT_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.ATTRIBUTES

Records user-defined type attributes.

Column name	Data type	Description
UDT_SYSID	INTEGER	System identifier for the user-defined type, to which the attribute belongs.
ATTRIBUTE_ID	INTEGER	System identifier for the attribute.
ATTRIBUTE_NAME	NCHAR_VARYING(128)	Attribute name.
ORDINAL_POSITION	INTEGER	The ordinal position of the attribute in the user-defined type. The first attribute is number 1.
COLLATION_SYSID	INTEGER	System identifier for the collation used by the attribute.
CHARSET_SYSID	INTEGER	System identifier for the attribute’s character set.
ATTRIBUTE_UDT_SYSID	INTEGER	System identifier for the attribute’s data type, if user-defined type.
DATA_TYPE	VARCHAR(30)	The data type of the attribute. 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 USER-DEFINED.
INTERVAL_TYPE	VARCHAR(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.
INTERNAL_TYPE	INTEGER	System identifier for data type.
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_OFFSET	INTEGER	Internal offset for attribute in type.
IS_NULLABLE	BOOLEAN	Nullability attribute TRUE = The attribute can be null FALSE = The attribute can not be null
OBSERVER_METHOD	INTEGER	System identifier for observer method for attribute.
MUTATOR_METHOD	INTEGER	System identifier for mutator method for attribute.
OBSERVER_METHOD_ SPECIFICATION	INTEGER	System identifier for observer method specification for attribute.
MUTATOR_METHOD_ SPECIFICATION	INTEGER	System identifier for mutator method specification for attribute.
INTERNAL_LENGTH	INTEGER	Internal length in bytes of attribute.
AS_LOCATOR	BOOLEAN	One of: TRUE = declared as locator FALSE = not locator

Primary key: UDT_SYSID, ATTRIBUTE_ID

Unique constraint: UDT_SYSID, ORDINAL_POSITION

Unique constraint: UDT_SYSID, ATTRIBUTE_NAME

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.

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(400)	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	VARCHAR(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_ID	INTEGER	Column identifier.
COLUMN_NAME	NCHAR VARYING(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.
DATA_TYPE	VARCHAR(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 USER-DEFINED.
INTERVAL_TYPE	VARCHAR(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.
INTERNAL_TYPE	INTEGER	System identifier for the internal data type.
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	BOOLEAN	One of: FALSE = the column is not nullable, according to the rules in the international standard TRUE = the null value is allowed in the column.
IS_UPDATABLE	BOOLEAN	One of: FALSE = the column is not updatable TRUE = the column is updatable.
IS_INSTEAD_OF	BOOLEAN	One of: FALSE = the updatability of the column does not depend on an instead of trigger TRUE = the updatability of the column depends on an instead of trigger.
INTERNAL_LENGTH	INTEGER	Internal length in bytes of value.
INTERNAL_INDEX	INTEGER	Internal index for value in record.
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.
CHARSET_SYSID	INTEGER	System identifier for the character set used by the column.
UDT_SYSID	INTEGER	System identifier for a user-defined type.
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	BINARY(16)	Lowest value in column.
COLUMN_HIGH_VALUE	BINARY(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.

Primary key: TABLE_SYSID, COLUMN_ID

Unique constraint: COLUMN_NAME, TABLE_SYSID

Unique constraint: TABLE_SYSID, ORDINAL_POSITION

Secondary index: TABLE_SYSID, INTERNAL_INDEX, 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_SYSID	INTEGER	System identifier for the object on which the column depends.
TABLE_SYSID	INTEGER	System identifier for the table or view.
COLUMN_ID	INTEGER	Id for the column.

Primary key: OBJECT_SYSID, TABLE_SYSID, COLUMN_ID

Secondary index: TABLE_SYSID, COLUMN_ID

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_ID	INTEGER	The id of the table or view column.
PRIVILEGE_TYPE	VARCHAR(20)	One of: INSERT REFERENCES SELECT UPDATE.
GRANTEE_SYSID	INTEGER	The sysid of the ident to whom the privilege was granted.
GRANTOR_SYSID	INTEGER	The sysid of the ident granting the privilege.
IS_GRANTABLE	BOOLEAN	One of: FALSE = WITH GRANT OPTION is not held for the privilege TRUE = WITH GRANT OPTION is held for the privilege.
IS_INSTEAD_OF	BOOLEAN	One of: FALSE = The privilege has been granted explicitly TRUE = 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_ID, PRIVILEGE_TYPE, GRANTEE_SYSID, GRANTOR_SYSID

Secondary index: GRANTEE_SYSID

Secondary index: GRANTOR_SYSID

SYSTEM.COMMENTS

Comments on objects in the database.

Column name	Data type	Description
OBJECT_SYSID	INTEGER	System identifier for object.
COLUMN_ID	INTEGER	Column ordinal position, 0 if comment is not on column.
COMMENT	NCHAR VARYING(254)	Comment.

Primary key: OBJECT_SYSID, COLUMN_ID

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	NCHAR VARYING(128)	The name of the databank.
SHADOW_NAME	NCHAR VARYING(128)	The shadow name if the databank is a shadow.
DATABANK_FILENAME	NCHAR VARYING(256)	The path name for the databank file.
DATABANK_TYPE	VARCHAR(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	BOOLEAN	One of: FALSE = the databank is a shadow TRUE = the databank is a master.
IS_ONLINE	BOOLEAN	One of: FALSE = the databank is OFFLINE TRUE = 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	BOOLEAN	One of: FALSE = databank is not removable TRUE = databank is removable
BACKUPED	TIMESTAMP(2)	Last date for backup, currently always set to null
SEQTABLE_SYSID	INTEGER	System id for the sequence table. Null if no sequence in databank.

Primary key: DATABANK_SYSID, DATABANK_SEQNO, DATABANK_FILENO

Unique constraint: SHADOW_NAME, DATABANK_FILENO

Secondary index: DATABANK_NAME, DATABANK_SEQNO

SYSTEM.DIRECT_SUPERTYPES

Contains information about inheritance relation between user-defined types. (Currently not used.)

Column name	Data type	Description
UDT_SYSID	INTEGER	System identifier for the user-defined type.
UDT_SUPERTYPE_SYSID	INTEGER	System identifier for user-defined type used in inheritance.

Primary key: UDT_SYSID, UDT_SUPERTYPE_SYSID

Secondary index: UDT_SUPERTYPE_SYSID

SYSTEM.DOMAINS

Records the domains in the database.

Column name	Data type	Description
DOMAIN_SYSID	INTEGER	System identifier for the domain.
COLLATION_SYSID	INTEGER	System identifier for the collation for a domain associated with a character set.
CHARSET_SYSID	INTEGER	System identifier for the character set.
DATA_TYPE	VARCHAR(30)	Identifies the data type of the domain. 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 USER-DEFINED.
INTERVAL_TYPE	VARCHAR(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.
INTERNAL_TYPE	INTEGER	System identifier for the internal data type.
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	BOOLEAN	One of: FALSE = There are no constraints for the domain TRUE = There are constraints for the domain.
IS_LEVEL2_APPROVED	BOOLEAN	One of: FALSE = Tables using this domain can not be used with the level 2 interface TRUE = 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	BOOLEAN	One of: FALSE = the constraint is not deferrable. TRUE = the constraint is deferrable.
INITIALLY_DEFERRED	BOOLEAN	One of: FALSE = the constraint is not initially deferred TRUE = the constraint is initially deferred.

Primary key: DOMAIN_SYSID, CONSTRAINT_SYSID

Secondary index: 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_SOU_LENGTH	INTEGER	Length of source text in characters.
STATEMENT_SOURCE	NCHAR VARYING(200)	Source text for the precompiled statement. If the length exceeds 200 characters, this value is null and the source text is stored in SOURCE_DEFINITION.
INLINE	BOOLEAN	One of: FALSE = the statement is not inline TRUE = the statement is inline.

Primary key: STATEMENT_SYSID

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	VARCHAR(50)	The name of the FIPS feature.
CLASSIFICATION	VARCHAR(12)	The conformance level of the feature. One of: TRANSITIONAL INTERMEDIATE FULL.
IS_SUPPORTED	BOOLEAN	One of: TRUE = Mimer SQL supports the feature FALSE = Mimer SQL does not support the feature.
IS_VERIFIED	BOOLEAN	One of: TRUE = Mimer SQL support for the feature has been tested and verified FALSE = 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	VARCHAR(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.HEURISTICS

Holds information about distributed transactions.

Column name	Data type	Description
COMMIT_ID	BINARY(128)
HEURISTIC_OPCODE	INTEGER
COMMIT_PROTOCOL	INTEGER
FORMAT_ID	INTEGER
GTRID_LENGTH	INTEGER
BQUAL_LENGTH	INTEGER

Primary key: COMMIT_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_ID	INTEGER	The id of the table column.
KEY_TYPE	VARCHAR(20)	One of: FOREIGN KEY INDEX INTERNAL KEY PRIMARY KEY UNIQUE.
IS_UNIQUE	BOOLEAN	One of: FALSE = the column may contain non-unique values TRUE = the column is constrained to contain only unique values.
IS_ASCENDING	BOOLEAN	One of: FALSE = the column is indexed in descending value order TRUE = the column is indexed in ascending value order.
COLLATION_SYSID	INTEGER	System identifier for the collation used by the index.
INDEX_ALGORITHM	VARCHAR(20)	Algorithm used when creating index.
ATTRIBUTE_SYSID	INTEGER	System identifier for user-defined type if index defined on attribute in structured type.
ATTRIBUTE_NUMBER	INTEGER	Ordinal position for attribute within user defined structured type.
ATTRIBUTE_OFFSET	INTEGER	Offset for attribute within user-defined type.
INTERNAL_TYPE	INTEGER	Data type for index column.
SIZE	INTEGER	Precision of index column data type.
SCALE	INTEGER	Scale for index column data type.

Primary key: TABLE_SYSID, CONSTRAINT_SYSID, ORDINAL_POSITION

Unique constraint: CONSTRAINT_SYSID, COLUMN_ID

SYSTEM.LEVEL2_RESTRICT

Records restrictions for domains legal for use by Level 2.

Column name	Data type	Description
DOMAINID	INTEGER	System identifier for the domain with restrictions.
SEQNO	SMALLINT	Restriction order number.
LOGOP	CHAR(3)	Logical operator (AND, OR).
RELOP	CHAR(2)	Relational operator (EQ, …).
LENGTH	SMALLINT	Length of the value.
RESVALUE	VARCHAR(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	INTEGER	View table identifier.
VCOLNO	SMALLINT	View table column number.
BTABID	INTEGER	Base table identifier.
BCOLNO	SMALLINT	Base table column number.

Primary key: VTABID, VCOLNO

SYSTEM.LEVEL2_VIEWRES

Records restrictions for DB level 2.

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

Primary key: VTABID, SEQNO

SYSTEM.LIBRARIES

Records external libraries.

Column name	Data type	Description
LIBRARY_SYSID	INTEGER	System identifier for external library.
LIBRARY_FILENAME	NCHAR VARYING(256)	File name for external library.

Primary key: LIBRARY_SYSID

Secondary index: LIBRARY_FILENAME

SYSTEM.LOGINS

Records OS_USER logins for user idents.

Column name	Data type	Description
USER_LOGIN	NCHAR VARYING(128)	OS_USER name.
USER_SYSID	INTEGER	System identifier for the ident.

Primary key: USER_LOGIN, USER_SYSID

Secondary index: USER_SYSID

SYSTEM.MANYROWS

Dummy table with more than one row.

Column name	Data type	Description
C	SMALLINT	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	VARCHAR(80)	Message text.

Primary key: MODULEID, MESSAGEID, LANGUAGE, LINENO

SYSTEM.METHOD_SPECIFICATION_PARAMETERS

Records parameters to method specifications.

Column name	Data type	Description
METHOD_SYSID	INTEGER	System identifier for the method specification.
ORDINAL_POSITION	INTEGER	The ordinal position of the parameter in the method specification. The first parameter is number 1.
PARAMETER_NAME	NCHAR VARYING(128)	The name of the parameter.
PARAMETER_MODE	CHAR(5)	One of: IN OUT INOUT.
IS_RESULT	BOOLEAN	One of TRUE = The parameter is a result parameter FALSE = The parameter is not a result parameter
UDT_SYSID	INTEGER	System identifier for the parameter’s type, if it’s a user-defined type.
COLLATION_SYSID	INTEGER	System identifier of the collation associated with the parameter.
CHARSET_SYSID	INTEGER	The system identifier for the character set.
DATA_TYPE	VARCHAR(30)	The data type of the parameter. 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 USER-DEFINED.
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.
INTERNAL_TYPE	INTEGER	System identifier for the internal data type.
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.
AS_LOCATOR	BOOLEAN	One of: TRUE = declared as locator FALSE = not locator
INTERNAL_LENGTH	INTEGER	Internal length.
DOMAIN_SYSID	INTEGER	System identifier for domain, when a domain is used as the type for a parameter in a method specification.

Primary key: METHOD_SYSID, ORDINAL_POSITION

Unique constraint: METHOD_SYSID, PARAMETER_NAME

SYSTEM.METHOD_SPECIFICATIONS

Records method specifications.

Column name	Data type	Description
METHOD_SYSID	INTEGER	System identifier for the method specification.
UDT_SYSID	INTEGER	System identifier for user-defined type, to which the method is specified.
IS_STATIC	BOOLEAN	One of TRUE = Method specification is static FALSE = Method specification is not static
IS_OVERRIDING	BOOLEAN	One of TRUE = Method specification is overriding FALSE = Method specification is not overriding
IS_CONSTRUCTOR	BOOLEAN	One of TRUE = Method specification is a constructor method FALSE = Method specification is not a constructor method
IS_DETERMINISTIC	BOOLEAN	One of: FALSE = The routine is not deterministic. i.e. invoking the routine with the same input values is not guaranteed to return the same result TRUE = The routine is deterministic, i.e. when invoked with same input values it will always return the same result.
IS_NULL_CALL	BOOLEAN	One of: TRUE = method will be invoked when parameters are null FALSE = method will not be invoked when parameters are null and returns null. (currently not used)
SQL_DATA_ACCESS	VARCHAR(20)	One of: NO SQL CONTAINS SQL READS SQL DATA MODIFIES SQL DATA.
METHOD_LANGUAGE	VARCHAR(20)	Language used for method. One of: SQL (currently not used)
PARAMETER_STYLE	VARCHAR(20)	The parameter passing style of the routine if it is an external routine, otherwise the null value is shown.
RESULT_UDT_SYSID	INTEGER	System identifier for the result data type, if it’s a user-defined type.
COLLATION_SYSID	INTEGER	System identifier of the collation associated with the result.
CHARSET_SYSID	INTEGER	The system identifier for the character set.
DATA_TYPE	VARCHAR(30)	The data type of the result. 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 USER-DEFINED.
INTERVAL_TYPE	VARCHAR(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.
INTERNAL_TYPE	INTEGER	System identifier for the internal data type.
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.
TOTAL_PARAMS	INTEGER	The number of parameters. (Described in SYSTEM.METHOD_SPECIFICATION_PARAMETERS.)
AS_LOCATOR	BOOLEAN	One of: TRUE = declared as locator FALSE = not locator
INTERNAL_LENGTH	INTEGER	Internal length.
SELF_AS_RESULT	BOOLEAN	One of: TRUE = returns self FALSE = does not return self
DOMAIN_SYSID	INTEGER	System identifier for domain, when a domain is used as the return type for a method.

Primary key: METHOD_SYSID

Secondary index: UDT_SYSID

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.

Primary key: MODULE_SYSID

SYSTEM.NANO_DATABANKS

Contains information about Mimer Nano databanks. (Currently not used.)

SYSTEM.NANO_DESCRIPTORS

Contains information about Mimer Nano descriptors. (Currently not used.)

SYSTEM.NANO_OBJECTS

Contains information about Mimer Nano objects. (Currently not used.)

SYSTEM.NANO_ROUTINE_USE

Contains information about Mimer Nano routine usage. (Currently not used.)

SYSTEM.NANO_USERS

Contains information about Mimer Nano databanks. (Currently not used.)

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_ID	INTEGER	The id of the table column.
USED_BY_SYSID	INTEGER	The system identifier of the referencing object.
USED_BY_TYPE	VARCHAR(20)	One of: VIEW PROCEDURE FUNCTION METHOD CHECK TRIGGER USER DEFINED TYPE STATEMENT.
PRIVILEGE_TYPE	VARCHAR(20)	One of: INSERT DELETE SELECT UPDATE REFERENCES.

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

Secondary index: USED_BY_SYSID

SYSTEM.OBJECT_OBJECT_USE

Records objects referenced by other objects.

Column name	Data type	Description
OBJECT_SYSID	INTEGER	System identifier for the object used.
USED_BY_SYSID	INTEGER	The system identifier of the referencing object.
IS_STRONG	BOOLEAN	Determines if a dependent object will be dropped when dropping the object on which this object depends. One of: FALSE = the dependent object will be dropped even if drop restrict is specified TRUE = the object will only be dropped if cascade is specified.
OBJECT_TYPE	VARCHAR(20)	One of: BASE TABLE DATABANK INDEX VIEW PROCEDURE FUNCTION METHOD METHOD SPECIFICATION DOMAIN SEQUENCE CHARACTER SET COLLATION TRANSLATION TRIGGER USER DEFINED TYPE STATEMENT.
USED_BY_TYPE	VARCHAR(20)	One of: BASE_TABLE VIEW PROCEDURE FUNCTION METHOD METHOD SPECIFICATION DOMAIN TRIGGER CHARACTER SET COLLATION CHECK INDEX STATEMENT.

Primary key: OBJECT_SYSID, USED_BY_SYSID

Secondary index: USED_BY_SYSID

SYSTEM.OBJECT_PROGRAMS

Contains information about predefined executable statements for table operations and routines.

Column name	Data type	Description
OBJECT_SYSID	INTEGER	System identifier for object.
OPERATION	VARCHAR(20)	Type of operation, one of: DELETE INSERT UPDATE '' (empty string), routine invocation
STATEMENT_SYSID	INTEGER	System identifier for executable statement.

Primary key: OBJECT_SYSID, OPERATION

Secondary index: STATEMENT_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 CONSTRUCTOR METHOD DATABANK DOMAIN FUNCTION IDENT INDEX INSTANCE METHOD METHOD SPECIFICATION MODULE PROCEDURE SCHEMA SEQUENCE SHADOW STATEMENT STATIC METHOD SYNONYM TRANSLATION TRIGGER USER DEFINED TYPE VIEW.
OBJECT_SCHEMA	NCHAR VARYING(128)	The name of the schema containing the object.
OBJECT_NAME	NCHAR VARYING(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.
IS_IMPLICIT	BOOLEAN	One of: TRUE = the object is created implicitly as the result of another CREATE statement FALSE = the object is created explicitly.
SPECIFIC_SYSID	INTEGER	Specific id for overloaded routines.
COMPATIBILITY	INTEGER	Indicates which compatibility mode was set when the object was created.
LAST_DEPENDENCY_SYSID	INTEGER	Upper limit for scope when resolving object references in routines and triggers.

Primary key: OBJECT_SYSID

Unique constraint: OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME, SPECIFIC_SYSID

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_RETURN	BOOLEAN	For a type preserving method this column indicates whether the parameter is type preserving or not. One of TRUE FALSE
PARAMETER_MODE	CHAR(5)	One of: IN OUT INOUT.
PARAMETER_NAME	NCHAR VARYING(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. 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 USER-DEFINED.
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.
INTERNAL_TYPE	INTEGER	System identifier for the internal data type.
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.
AS_LOCATOR	BOOLEAN	One of: TRUE = declared as locator FALSE = not locator
INTERNAL_LENGTH	INTEGER	Internal length.
IS_RESULT	BOOLEAN	One of: FALSE = This parameter is not part of the result clause for a result set procedure TRUE = This parameter is part of the result set.

Primary key: ROUTINE_SYSID, ORDINAL_POSITION, IS_RETURN

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.
IS_CONSISTENT	BOOLEAN	Indicates if the foreign key constraint is consistent. One of: TRUE FALSE A foreign key constraint will be marked as inconsistent if the system databank transdb is dropped or if the databank in which the referenced or referencing table is located is set to work option.
MATCH_OPTION	VARCHAR(20)	One of: NONE PARTIAL FULL.
UPDATE_RULE	VARCHAR(20)	One of: CASCADE SET NULL SET DEFAULT NO ACTION RESTRICT.
DELETE_RULE	VARCHAR(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

Secondary index: CONSTRAINT_SYSID

Secondary index: 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	VARCHAR(20)	One of: PROCEDURE FUNCTION.
SQL_DATA_ACCESS	VARCHAR(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 200 characters, this value is null and the source text is stored in SOURCE_DEFINITION.
IS_DETERMINISTIC	BOOLEAN	One of: FALSE = The routine is not deterministic. i.e. invoking the routine with the same input values is not guaranteed to return the same result TRUE = The routine is deterministic, i.e. when invoked with same input values it will always return the same result.
ROUTINE_BODY	VARCHAR(20)	One of: SQL = The routine is an SQL routine EXTERNAL = The routine is external
EXTERNAL_NAME	NCHAR VARYING(128)	The name of the program that implements the routine if it is an external routine otherwise null.
EXTERNAL_LANGUAGE	VARCHAR(20)	The language for the routine if it is external otherwise null.
PARAMETER_STYLE	VARCHAR(20)	The parameter passing style for the routine if it is an external routine, otherwise null.
SCHEMA_LEVEL_ROU	BOOLEAN	One of: FALSE = The routine is defined within a module TRUE = 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	System identifier for user-defined type, if routine is a method.
IS_USER_DEFINED_CAST	BOOLEAN	(currently not used)
IS_IMPLICITLY_INVOCABLE	BOOLEAN	(currently not used)
MS_SYSID	INTEGER	(currently not used)
IS_NULL_CALL	BOOLEAN	One of: TRUE = routine will be called if all parameters are null FALSE = routine returns null if all parameters are null
OVERRIDING_SYSID	INTEGER	System identifier for original method specification.
ROUTINE_HEADER_OFFSET	INTEGER	Offset for routine header in source definition.
ROUTINE_HEADER_LENGTH	INTEGER	Length of routine header.
ROUTINE_RETURNS_OFFSET	INTEGER	Offset for returns clause in source definition.
ROUTINE_RETURNS_LENGTH	INTEGER	Length of return clause.
ROUTINE_SPECIFIC_OFFSET	INTEGER	Offset for specific clause in source definition.
ROUTINE_SPECIFIC_LENGTH	INTEGER	Length of specific clause.
ROUTINE_EXTERNAL_OFFSET	INTEGER	Offset for external clause in source definition.
ROUTINE_EXTERNAL_LENGTH	INTEGER	Length of external clause.
ROUTINE_BODY_OFFSET	INTEGER	Offset for routine body in source definition.
ROUTINE_BODY_LENGTH	INTEGER	Length of routine body.
LIBRARY_SYSID	INTEGER	System identifier for external library.
ROUTINES_IS_INVOKED_ MANY	BOOLEAN	The column indicates whether a function or method should be invoked multiple times or only once within a statement.

Primary key: ROUTINE_SYSID

Secondary index: LIBRARY_SYSID

Secondary index: MODULE_SYSID

Secondary index: OVERRIDING_SYSID

Unique constraint: MS_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.

Primary key: SCHEMA_SYSID

SYSTEM.SEQUENCE_VALUE_TABLE

Stores information about sequences.

Column name	Data type	Description
SEQ_SYSID	INTEGER	System identifier of the sequence.
CURRENT_VALUE	BIGINT	Current value for sequence.
CYCLES	BIGINT	Number of times the sequence has reached its maximum value.
IS_EXHAUSTED	INTEGER	Indicates whether a unique sequences has reached its maximum value. One of: 1 = sequence has reached its maximum value 0 = sequence has not reached its maximum value

Primary key: SEQ_SYSID

SYSTEM.SEQUENCES

Records sequences in the database.

Column name	Data type	Description
SEQUENCE_SYSID	INTEGER	System identifier of the sequence.
DATA_TYPE	VARCHAR(30)	One of: SMALLINT INTEGER BIGINT.
INTERNAL_TYPE	INTEGER	System identifier of internal data type.
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	BOOLEAN	One of: TRUE = the sequence will restart when all values are exhausted FALSE = 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	BOOLEAN	One of: TRUE = the series of values defined by the sequence is exhausted FALSE = the series of values defined by the sequence is not exhausted.
CYCLES	BIGINT	Number of times the maximum value of the sequence is exceeded.
FLUSH_RATE	BIGINT	Number of sequence value allocations between saving sequence data to disk.
DATABANK_SYSID	INTEGER	Databank location.
INTERNAL_LENGTH	INTEGER	Internal length.

Primary key: SEQUENCE_SYSID

SYSTEM.SERVER_INFO

Records attributes of the current database system or server.

Column name	Data type	Description
SERVER_ATTRIBUTE	VARCHAR(100)	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(100)	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	VARCHAR(20)	Name of Mimer SQL module to which the message belongs.
SQLSTATE_VALUE	CHAR(5)	Corresponding SQLSTATE value for message.
CLASS_ORIGIN	VARCHAR(20)	Class origin for the SQLSTATE value.
SUBCLASS_ORIGIN	VARCHAR(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_ID	INTEGER	Column id if the source types is a default value for a column. Null otherwise.
SOURCE_TYPE	VARCHAR(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_ID, 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	NCHAR VARYING(128)	The name of the schema containing the routine.
SPECIFIC_NAME	NCHAR VARYING(128)	The specific name for the routine.
UDT_SYSID	INTEGER	System identifier for user-defined type if routine is a method.

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	VARCHAR(20)	Identification of the conformance element described.
CONFORMANCE_SUB_ID	VARCHAR(20)	If the conformance element is a subfeature then it's identification, otherwise a single space.
CONFORMANCE_TYPE	VARCHAR(20)	Type of conformance element. FEATURE, SUBFEATURE, PACKAGE, or PART.
CONFORMANCE_IS_CORE_SQL	BOOLEAN	TRUE if the conformance element belongs to Core SQL, otherwise FALSE.
CONFORMANCE_NAME	VARCHAR(100)	Short description of the conformance element.
CONFORMANCE_SUB_NAME	VARCHAR(130)	Short description of a subfeature, otherwise a single space.
CONFORMANCE_IS_SUPPORTED	BOOLEAN	TRUE if fully supported by Mimer SQL, otherwise FALSE.
CONFORMANCE_IS_VERIFIED_BY	BOOLEAN	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
ORDINAL_NO	INTEGER	Ordinal number.
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.

Primary key: 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_TYPE	INTEGER	Internal. Naming or section descriptor type.
DESC_MODE	INTEGER	Mode, one of: 1 = no scroll 2 = scroll
DESC_SEQNO	INTEGER	Sequence number for compiled code.
DESC_VERSION	INTEGER	Compiler version used.
DESC_CODE_LENGTH	INTEGER	Length of compiled code.
DESC_CODE	BINARY(1000)	Compiled code.

Primary key: STATEMENT_SYSID, DESC_TYPE, DESC_MODE, DESC_SEQNO

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.
ROUTINE_SYSID	INTEGER	System identifier for called routines.

Primary key: STATEMENT_SYSID, USE_SEQNO

Secondary index: ROUTINE_SYSID

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

Secondary index: ORDINARY_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	VARCHAR(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	BOOLEAN	One of: TRUE = The table can be used with level 2 DB interface. FALSE = The table cannot be used with level 2 DB interface.
IS_PERSISTENT	BOOLEAN	One of: FALSE = The table is a temporary table TRUE = 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.
VARIABLE	INTEGER	Number of length field entries.
IS_VARIABLE	BOOLEAN	One of: TRUE = The table has variable format FALSE = The table has fixed format
COMMIT_ACTION	VARCHAR(20)	Indicates what happens with records in a temporary table at commit. One of: DELETE PRESERVE The column will be null if the table is not temporary.

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_SYSID	INTEGER	System identifier of the constraint.
CONSTRAINT_TYPE	VARCHAR(20)	One of: PRIMARY KEY UNIQUE FOREIGN KEY INDEX INDEX UNIQUE INTERNAL KEY CHECK.
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	BOOLEAN	One of: FALSE = The index may be inconsistent and should not be used for index lookup only TRUE = The index may be used for index lookup only.
IS_DEFERRABLE	BOOLEAN	One of: FALSE = The constraint is not deferrable TRUE = The constraint is deferrable.
INITIALLY_DEFERRED	BOOLEAN	One of: FALSE = The constraint is immediate TRUE = The constraint is not immediate.
VARIABLE	INTEGER	Number of length field entries.
LATEST_ROOTID	INTEGER	The latest value for the internal identifier for a constraint or index. The internal identifier can change if the table on which the constraint or index is defined is altered.
ON_CONFLICT	VARCHAR(20)	Possible behavior when a constraint is violated. Currently this value is always ABORT.

Primary key: TABLE_SYSID, 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	VARCHAR(20)	One of: DELETE INSERT LOAD REFERENCES SELECT UPDATE TRIGGER.
GRANTEE_SYSID	INTEGER	The sysid of the ident to whom the table privilege was granted.
GRANTOR_SYSID	INTEGER	The sysid of the ident granting the table privilege.
IS_GRANTABLE	BOOLEAN	One of: TRUE = WITH GRANT OPTION is held with the privilege FALSE = WITH GRANT OPTION is not held with the privilege.
IS_INSTEAD_OF	BOOLEAN	One of: FALSE = The privilege was granted explicitly TRUE = The privilege was granted implicitly when an instead of trigger was created.
IS_ON_TABLE	BOOLEAN	One of: FALSE = The privilege was granted on individual columns TRUE = The privilege was granted on the complete table.
ALL_COLUMNS	BOOLEAN	One of: TRUE = the privilege was granted on the table and therefore applies to all table columns, including new ones added FALSE = the privilege only applies to the table columns explicitly specified when the privilege was granted.

Primary key: TABLE_SYSID, PRIVILEGE_TYPE, GRANTEE_SYSID, GRANTOR_SYSID

Secondary index: GRANTEE_SYSID

Secondary index: GRANTOR_SYSID

SYSTEM.TABLE_TYPES

Records the types of table supported.

Column name	Data type	Description
TABLE_TYPE	VARCHAR(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_ID	INTEGER	The id of the column in which updates will cause the trigger to execute.

Primary key: TRIGGER_SYSID, EVENT_TABLE_SYSID, EVENT_COLUMN_ID

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	VARCHAR(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, 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	VARCHAR(20)	One of: ROW STATEMENT.
CONDITION_TIMING	VARCHAR(20)	One of: BEFORE AFTER INSTEAD OF.
COND_REF_NEW_TABLE	NCHAR VARYING(128)	Name of new table/row alias.
COND_REF_OLD_TABLE	NCHAR VARYING(128)	Name of old table/row alias.
REFERENCE_NEW	BOOLEAN	One of: FALSE = The trigger has no new table/row alias TRUE = The trigger has new table/row alias.
REFERENCE_OLD	BOOLEAN	One of: FALSE = The trigger has no new table/row alias TRUE = The trigger has new table/row alias.
COLS_IS_IMPLICIT	BOOLEAN	One of: FALSE = The trigger is invoked on update on any column (if the event is update) TRUE = 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
INTERNAL_TYPE	INTEGER	System identifier of the internal data type.
DATA_TYPE	SMALLINT	Identification number for data type.
TYPE_NAME	VARCHAR(30)	Name of data type. 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 USER-DEFINED.
COLUMN_SIZE	INTEGER	Length of data type name.
LITERAL_PREFIX	VARCHAR(30)	Optional prefix for a literal of this type.
LITERAL_SUFFIX	VARCHAR(30)	Optional suffix for a literal of this type.
CREATE_PARAMS	VARCHAR(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	VARCHAR(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	Subtype 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	VARCHAR(30)	Internal type name.
INTERNAL_VERSION	SMALLINT	Internal version number.
INTERNAL_TYPEORDER	SMALLINT	Internal type ordering number.

Primary key: INTERNAL_TYPE, DATA_TYPE

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	VARCHAR(20)	One of: BACKUP CHARACTER SET COLLATION DATABANK DOMAIN FUNCTION IDENT METHOD PROGRAM SCHEMA SEQUENCE_ON_DATABANK SHADOW STATEMENT STATISTICS TABLE USER DEFINED TYPE
GRANTEE_SYSID	INTEGER	The id of the ident to whom the usage privilege was granted.
GRANTOR_SYSID	INTEGER	The id of the ident granting the usage privilege.
IS_GRANTABLE	BOOLEAN	One of: TRUE = WITH GRANT OPTION is held with the privilege FALSE = WITH GRANT OPTION is not held with the privilege.
IS_IMPLICIT	BOOLEAN	One of: TRUE = The privilege has been granted implicitly as the result of another grant statement FALSE = The privilege has been granted implicitly.

Primary key: OBJECT_SYSID, OBJECT_PRIVILEGE, GRANTEE_SYSID, GRANTOR_SYSID

Secondary index: GRANTEE_SYSID

Secondary index: GRANTOR_SYSID

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	VARCHAR(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	VARCHAR(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 USER-DEFINED.
INTERVAL_TYPE	VARCHAR(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_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.
INTERNAL_TYPE	INTEGER	System identifier of the internal data type.
INTERNAL_LENGTH	INTEGER	Internal length in bytes of value.
MAX_INTERNAL_LENGTH	INTEGER	Length of the type’s longest subtype.
IS_INSTANTIABLE	BOOLEAN	One of: TRUE = the structured user-defined type can be instantiated FALSE = the structured user-defined type cannot be instantiated.
IS_FINAL	BOOLEAN	One of: TRUE = the structured user-defined type cannot be used as a supertype FALSE = the structured user-defined type can be used as a supertype.
ORDERING_FORM	VARCHAR(20)	One of: NONE, comparison not allowed for instances of the structured user-defined type EQUALS, only equality comparisons allowed for instances of the structured user-defined type FULL, all possible comparisons allowed for instances of the structured user-defined type.
ORDERING_CATEGORY	VARCHAR(20)	One of: RELATIVE, comparisons are done with a relative ordering function STATE, comparisons are done with a state ordering function MAP, comparisons are done with a map ordering function
ORDERING_ROUTINE_SYSID	INTEGER	System identifier for ordering function.
ORDERING_SYSID	INTEGER	System identifier for ordering.
NO_OF_ATTRIBUTES	INTEGER	Number of attributes in a structured user-defined type, 0 if user-defined type is distinct.
CONSTRUCTOR_FUNCTION	INTEGER	System identifier for constructor function, 0 if user-defined type is distinct.
OBSERVER_METHOD	INTEGER	System identifier for observer method, 0 if user-defined type is structured.
TOTAL_DEFAULT_LENGTH	INTEGER	Total length in bytes for all default values for attributes in a structured user-defined type.
TOTAL_ATTRIBUTE_NAME_LENGTH	INTEGER	Total length for all attribute names in a structured user-defined type.
AS_LOCATOR	BOOLEAN	For a distinct type this indicates whether the base data type used in the type definition is declared AS LOCATOR or not. One of: TRUE FALSE
NO_OF_SUPERTYPES	INTEGER	Number of supertypes.
NO_OF_SUBTYPES	INTEGER	Number of subtypes.
NO_OF_INHERITED	INTEGER	Number of inherited.

Primary key: UDT_SYSID

Secondary index: ORDERING_SYSID

SYSTEM.USERS

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

Column name	Data type	Description
USER_NAME	NCHAR VARYING(128)	The ident name.
USER_SYSID	INTEGER	System identifier for the ident.
USER_TYPE	VARCHAR(20)	One of: USER OS_USER PROGRAM GROUP.
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	VARCHAR(20)	One of: CASCADED LOCAL NONE.
IS_UPDATABLE	BOOLEAN	One of: FALSE = The view can not be updated TRUE = The view can be updated.
IS_INSTEAD_OF	BOOLEAN	One of: FALSE = The view can be updated per se TRUE = 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. If the length of the text exceeds 200 characters, this value is null and the text is stored in SOURCE_DEFINITION.

Primary key: VIEW_SYSID