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.
ATTRIBUTES
Attributes of user-defined types. See SYSTEM.ATTRIBUTES.
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.
COMMENTS
Comments on objects. See SYSTEM.COMMENTS.
DATABANKS
Databanks in the database. See SYSTEM.DATABANKS.
DIRECT_SUPERTYPES
DOMAIN_CONSTRAINTS
Constraints defined for domains. See SYSTEM.DOMAIN_CONSTRAINTS.
DOMAINS
Domains in the database. See SYSTEM.DOMAINS.
EXEC_STATEMENTS
Precompiled statements. See SYSTEM.EXEC_STATEMENTS.
FIPS_FEATURES
Details about all FIPS features. See SYSTEM.FIPS_FEATURES.
FIPS_SIZING
Details about FIPS limits. See SYSTEM.FIPS_SIZING.
HEURISTICS
KEY_COLUMN_USAGE
Columns in an index or in a primary, unique or foreign key. See 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.
LOGINS
OS_USER logins for user idents. See SYSTEM.LOGINS.
MANYROWS
Dummy table with more than one row. See SYSTEM.MANYROWS.
MESSAGE
Translation of message code to message text. See SYSTEM.MESSAGE.
METHOD_SPECIFICATION_PARAMETERS
Method specification parameters. See SYSTEM.METHOD_SPECIFICATION_PARAMETERS.
METHOD_SPECIFICATIONS
Method specifications. See SYSTEM.METHOD_SPECIFICATIONS.
MODULES
SQL-server modules in the database. See SYSTEM.MODULES.
NANO_DATABANKS
(Currently not used.)
NANO_DESCRIPTORS
(Currently not used.)
NANO_OBJECTS
(Currently not used.)
NANO_ROUTINE_USE
(Currently not used.)
NANO_USERS
(Currently not used.)
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.
OBJECT_PROGRAMS
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.
SEQUENCE_VALUE_TABLE
Current values of sequences. See SYSTEM.SEQUENCE_VALUE_TABLE.
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, 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.
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.

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

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

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_PROGRAMS

Contains information about predefined executable statements for table operations and routines. (Currently not used.)

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.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
CHAR(3)
Determines if a dependent object will be dropped when dropping the object on which this object depends.
One of:
NO = the dependent object will be dropped even if drop restrict is specified
YES = 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.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.

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
CHAR(3)
One of:
YES = declared as locator
NO = 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

ROUTINE_HEADER_LENGTH
INTEGER

ROUTINE_RETURNS_OFFSET
INTEGER

ROUTINE_RETURNS_LENGTH
INTEGER

ROUTINE_SPECIFIC_OFFSET
INTEGER

ROUTINE_SPECIFIC_LENGTH
INTEGER

ROUTINE_EXTERNAL_OFFSET
INTEGER

ROUTINE_EXTERNAL_LENGTH
INTEGER

ROUTINE_BODY_OFFSET
INTEGER

ROUTINE_BODY_LENGTH
INTEGER

LAST_DEPENDENCY_SYSID
INTEGER

Primary key: ROUTINE_SYSID

Secondary index: OVERRIDING_SYSID

Secondary index: MODULE_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.
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.

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


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