Summary of Data Dictionary Tables
Table name
|
Description
|
API_FUNCTION
|
translation of id to function or module name. See API_FUNCTION. |
AST_CODES
|
binary representation of the search condition of views in the database (for internal use). See AST_CODES. |
AST_SOURCES
|
textual representation of view definitions and tables and domains with check constraints. See AST_SOURCES. |
BACKUPS
|
databank backups recorded in the database. See BACKUPS. |
CHAR_SETS
|
character sets in the database. See CHAR_SETS. |
CHECK_CONSTRAINTS
|
check constraints defined for tables and domains. See CHECK_CONSTRAINTS. |
COLLATIONS
|
character collations in the database. See COLLATIONS. |
COLUMNS
|
columns in tables or views. See COLUMNS. |
COLUMN_OBJECT_USE
|
columns that depend on other database objects. See COLUMN_OBJECT_USE. |
COLUMN_PRIVILEGES
|
instances of privileges granted on a column. See COLUMN_PRIVILEGES. |
DATABANKS
|
databanks in the database. See DATABANKS. |
DOMAINS
|
domains in the database. See DOMAINS. |
DOMAIN_CONSTRAINTS
|
constraints defined for domains. See DOMAIN_CONSTRAINTS. |
EXEC_STATEMENTS
|
precompiled statement. See EXEC_STATEMENTS. |
FIPS_FEATURES
|
details about all FIPS features. See FIPS_FEATURES. |
FIPS_SIZING
|
details about FIPS limits. See FIPS_SIZING. |
KEY_COLUMN_USAGE
|
columns in an index or in a primary, unique or foreign key. KEY_COLUMN_USAGE. |
LEVEL2_RESTRICT
|
restrictions for domains legal for use by DB level 2. See LEVEL2_RESTRICT. |
LEVEL2_VIEWCOL
|
columns of views acceptable by DB level 2. See LEVEL2_VIEWCOL. |
LEVEL2_VIEWRES
|
restrictions for DB level 2. See LEVEL2_VIEWRES. |
MANYROWS
|
dummy table with more than one row. See MANYROWS. |
MESSAGE
|
translation of message code to message text. See MESSAGE. |
MODULES
|
SQL-server modules in the database. See MODULES. |
OBJECTS
|
objects in the database. See OBJECTS. |
OBJECT_COLUMN_USE
|
columns referenced by other database objects. See OBJECT_COLUMN_USE. |
OBJECT_OBJECT_USE
|
objects that have a dependency on another object. See OBJECT_OBJECT_USE. |
ONEROW
|
dummy table containing one row. See ONEROW. |
PARAMETERS
|
parameters of routines in the database. See PARAMETERS. |
REFER_CONSTRAINTS
|
referential constraints in the database. See REFER_CONSTRAINTS. |
ROUTINES
|
procedures and user-defined functions in the database. See ROUTINES. |
SCHEMATA
|
schemas in the database. See SCHEMATA. |
SEQUENCES
|
sequences in the database. See SEQUENCES. |
SERVER_INFO
|
attributes of the current database system or server. See SERVER_INFO. |
SEVERITY
|
severity levels and optional module for error codes. See SEVERITY. |
SOURCE_DEFINITION
|
source definitions for defaults, check constraints, views, modules, procedures, functions and triggers. See SOURCE_DEFINITION. |
SPECIFIC_NAMES
|
specific names of the routines in the database. See SPECIFIC_NAMES. |
SQL_LANGUAGES
|
SQL standards and SQL dialects supported. See SQL_LANGUAGES. |
STATEMENT_DESCRIPTORS
|
compiled code for statements. See STATEMENT_DESCRIPTORS. |
STATEMENT_ROUTINE_USE
|
compiled routine used by precompiled statements. See STATEMENT_ROUTINE_USE. |
SYNONYMS
|
synonyms and shadows in the database. See SYNONYMS. |
TABLES
|
tables and views in the database. See TABLES. |
TABLE_CONSTRAINTS
|
table constraints in the database. See TABLE_CONSTRAINTS. |
TABLE_PRIVILEGES
|
instances of privileges granted on a table. See TABLE_PRIVILEGES. |
TABLE_TYPES
|
the types of table supported. See TABLE_TYPES. |
TRANSLATIONS
|
character translations in the database. See TRANSLATIONS. |
TRIGGERED_COLUMNS
|
table columns explicitly specified in an UPDATE trigger event. See TRIGGERED_COLUMNS. |
TRIGGERS
|
triggers in the database. See TRIGGERS. |
TYPE_INFO
|
information about data types supported. See TYPE_INFO. |
USAGE_PRIVILEGES
|
instances of privileges which grant the right to use a database object. See USAGE_PRIVILEGES. |
USERS
|
idents ( GROUP, OS_USER, PROGRAM or USER) in the database. See USERS. |
VIEWS
|
views in the database. See VIEWS. |
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
AST_CODES
Records the binary representation of the search condition of views in the database (for internal use).
Column name
|
Data type
|
Description
|
AST_SYSID
|
INTEGER
|
System identifier for the view. |
AST_VERSION
|
INTEGER
|
Current AST-revision version number. |
SEQUENCE_NO
|
INTEGER
|
Sequence number within representation. |
AST_LENGTH
|
INTEGER
|
Length of binary data in AST_CODE. |
AST_CODE
|
VARCHAR(2400)
|
Binary representation of the view search condition. |
Primary key: AST_SYSID, AST_VERSION, SEQUENCE_NO
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
|
NATIONAL VARCHAR(800)
|
Textual representation of view, domain or table. |
Primary key: ASTS_SYSID, SEQUENCE_NO
BACKUPS
Records databank backups recorded in the database.
Column name
|
Data type
|
Description
|
DATABANK_NAME
|
VARCHAR(128)
|
Name of the databank recorded in the backup. |
DATABANK_FILENO
|
INTEGER
|
File number of the databank file. |
BACKUP_TYPE
|
CHAR(2)
|
Type of backup:
BC = backup copy
BU = incremental copy
DL = drop log. |
BACKUP_DATE
|
CHAR(8)
|
Date the backup was taken. |
BACKUP_TIME
|
CHAR(6)
|
Time the backup was taken. |
BACKUP_USER
|
VARCHAR(128)
|
Ident name taking the backup. |
BACKUP_FILENAME
|
VARCHAR(256)
|
Name of the file containing the backup. |
BACKUP_TIMENO
|
INTEGER
|
Time order number. |
Primary key: DATABANK_NAME, DATABANK_FILENO, BACKUP_TYPE, BACKUP_DATE, BACKUP_TIME
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
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
|
NATIONAL VARCHAR(400)
|
The text of the search condition of the check constraint. If the text is too long or NULL value, it will be stored in the SOURCE_DEFINITION table. |
Primary key: CONSTRAINT_SYSID
COLLATIONS
Records character collations in the database.
Column name
|
Data type
|
Description
|
COLLATION_SYSID
|
INTEGER
|
System identifier for the collation. |
CHARSET_SYSID
|
INTEGER
|
System identifier for the character set. |
PAD_ATTRIBUTE
|
CHAR(20)
|
One of the following values:
NO PAD = the collation has the no pad attribute PAD SPACE = the collation has the pad space attribute. |
Primary key: COLLATION_SYSID
COLUMNS
Records table and view columns in the database.
Column name
|
Data type
|
Description
|
TABLE_SYSID
|
INTEGER
|
System identifier for the table or view. |
COLUMN_NAME
|
VARCHAR(128)
|
The name of the table or view column. |
ORDINAL_POSITION
|
INTEGER
|
The ordinal position of the column in the table. The first column in the table is number 1. |
DOMAIN_SYSID
|
INTEGER
|
System identifier for the domain used by the column. |
COLLATION_SYSID
|
INTEGER
|
System identifier for the collation used by the column. |
CHARSET_SYSID
|
INTEGER
|
System identifier for the character set used by the column. |
UDT_SYSID
|
INTEGER
|
System identifier for a user-defined type. |
DATA_TYPE
|
CHAR(30)
|
Identifies the data type of the column.
Can be one of the following:
BIGINT
BINARY
BINARY VARYING
BINARY LARGE OBJECT
CHARACTER
CHARACTER LARGE OBJECT
NATIONAL CHARACTER
NATIONAL CHARACTER VARYING
CHARACTER VARYING
DATE
DECIMAL
DOUBLE PRECISION
FLOAT
Float(p)
INTEGER
Integer(p)
INTERVAL
NUMERIC
REAL
SMALLINT
TIME
TIMESTAMP. |
INTERVAL_TYPE
|
CHAR(30)
|
For INTERVAL data types, this is a character string specifying the interval qualifier for the named interval data type, see the Mimer SQL Reference Manual. For other data types it is the NULL value. |
CHAR_MAX_LENGTH
|
BIGINT
|
For CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in characters or bytes as appropriate. For all other data types it is the NULL value. |
CHAR_OCTET_LENGTH
|
BIGINT
|
For a CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in octets. For all other data types it is the NULL value. (For single octet character sets, this is the same as CHAR_MAX_LENGTH.) |
NUMERIC_PRECISION
|
INTEGER
|
For NUMERIC data types, this shows the total number of decimal digits allowed in the column. For all other data types it is the NULL value. NUMERIC_PREC_RADIX indicates the units of measurement. |
NUMERIC_SCALE
|
INTEGER
|
For NUMERIC data types, this shows the total number of significant digits to the right of the decimal point. For INTEGER values this is 0. For all other types, it is the NULL value. |
NUMERIC_PREC_RADIX
|
INTEGER
|
For NUMERIC data types, the value 10 is shown because NUMERIC_PRECISION specifies a number of decimal digits. For all other data types it is the NULL value. NUMERIC_PRECISION and NUMERIC_PREC_RADIX can be combined to calculate the maximum number that the column can hold. |
DATETIME_PRECISION
|
INTEGER
|
For DATE, TIME, TIMESTAMP and interval data types, this column contains the number of digits of precision for the fractional seconds component. For other data types it is the NULL value. |
INTERVAL_PRECISION
|
INTEGER
|
For INTERVAL data types, this is the number of significant digits for the interval leading precision, see the Mimer SQL Reference Manual. For other data types it is the NULL value. |
IS_NULLABLE
|
CHAR(3)
|
One of:
NO = the column is not nullable, according to the rules in the international standard
YES = the NULL value is allowed in the column. |
IS_UPDATABLE
|
CHAR(3)
|
One of:
NO = the column is not updatable
YES = the column is updatable. |
IS_INSTEAD_OF
|
CHAR(3)
|
One of:
NO
YES. |
INTERNAL_LENGTH
|
INTEGER
|
Internal length in bytes of value. |
INTERNAL_OFFSET
|
INTEGER
|
Internal offset for value in record. |
INTERNAL_VC_OFFSET
|
INTEGER
|
Internal offset for field containing actual length for a varying length item. |
COLUMN_CARD
|
BIGINT
|
Number of unique values in column. |
COLUMN_CARD_NONULL
|
BIGINT
|
Number of values in column that are not null. |
COLUMN_LOW_VALUE
|
CHAR(16)
|
Lowest value in column. |
COLUMN_HIGH_VALUE
|
CHAR(16)
|
Highest value in column. |
COLUMN_DEFAULT
|
NATIONAL VARCHAR(400)
|
This shows the default value for the column. If the default value is a CHARACTER string, the value shown is the string enclosed in single quotes. If the default value is a NUMERIC LITERAL, the value is shown in its original character representation without enclosing quotes. If the default value is a DATE, TIME or TIMESTAMP, the value shown is the appropriate keyword (e.g. DATE) followed by the literal representation of the value enclosed in single quotes, see the Mimer SQL Reference Manual for a description of DATE, TIME and TIMESTAMP literals). If the default value is a pseudo-literal, the value shown is the appropriate keyword (e.g. CURRENT_DATE) without enclosing quotes. If the default value is the NULL value, the value shown is the keyword NULL without enclosing quotes. If the default value cannot be represented without truncation, then a zero-length string is stored. If no default value was specified then its value is the NULL value. The value of COLUMN_DEF is syntactically suitable for use in specifying default-value in a CREATE TABLE or ALTER TABLE statement. |
REMARKS
|
NATIONAL VARCHAR(254)
|
A comment on the column. If no comment has been defined a zero length string is stored. |
Primary key: TABLE_SYSID, COLUMN_NAME
Unique constraint: TABLE_SYSID, ORDINAL_POSITION
Secondary index: TABLE_SYSID, INTERNAL_OFFSET
COLUMN_OBJECT_USE
Records table or view columns that depend on other objects in the database.
.
Column name
|
Data type
|
Description
|
OBJECT_TYPE
|
CHAR(20)
|
One of:
DOMAIN
SEQUENCE
COLLATION. |
OBJECT_SYSID
|
INTEGER
|
System identifier for the object on which the column depends. |
TABLE_SYSID
|
INTEGER
|
System identifier for the table or view. |
COLUMN_NAME
|
VARCHAR(128)
|
The name of the table or view column. |
Primary key: OBJECT_TYPE, OBJECT_SYSID, TABLE_SYSID, COLUMN_NAME
Secondary index: TABLE_SYSID, COLUMN_NAME
COLUMN_PRIVILEGES
Records table or view columns that depend on other objects in the database.
.
Column name
|
Data type
|
Description
|
TABLE_SYSID
|
INTEGER
|
System identifier for the table or view. |
COLUMN_NAME
|
VARCHAR(128)
|
The name of the table or view column. |
PRIVILEGE_TYPE
|
CHAR(20)
|
One of:
INSERT
REFERENCES
SELECT
UPDATE. |
GRANTEE
|
VARCHAR(128)
|
The name of the ident to whom the privilege was granted. |
GRANTOR
|
VARCHAR(128)
|
The name of the ident granting the privilege. |
IS_GRANTABLE
|
CHAR(3)
|
One of:
NO = WITH GRANT OPTION is not held for the privilege
YES = WITH GRANT OPTION is held for the privilege. |
IS_INSTEAD_OF
|
CHAR(3)
|
One of:
NO = The privilege has been granted explicitly
YES = The privilege is granted because an instead of trigger has been defined on the view to which the column belongs. |
Primary key: TABLE_SYSID, COLUMN_NAME, PRIVILEGE_TYPE, GRANTEE, GRANTOR
Secondary index: GRANTEE
Secondary index: GRANTOR
DATABANKS
Records the databanks in the database.
Column name
|
Data type
|
Description
|
DATABANK_SYSID
|
INTEGER
|
System identifier for the databank.
|
DATABANK_SEQNO
|
INTEGER
|
The shadowing sequence number for the databank.
|
DATABANK_FILENO
|
INTEGER
|
The file number of the databank file. |
DATABANK_NAME
|
VARCHAR(128)
|
The name of the databank. |
SHADOW_NAME
|
VARCHAR(128)
|
The shadow name if the databank is a shadow. |
DATABANK_FILENAME
|
VARCHAR(256)
|
The path name for the databank file. |
DATABANK_TYPE
|
CHAR(20)
|
Indicates type of transaction handling:
LOG = transaction handling with logging
TRANS = transaction handling without logging
NULL = transaction handling not used
WORK = work databank (SQLDB). |
IS_MASTER
|
CHAR(3)
|
One of:
NO = the databank is a shadow
YES = the databank is a master. |
IS_ONLINE
|
CHAR(3)
|
One of:
NO = the databank is OFFLINE
YES = the databank of ONLINE. |
LOBDIR_SYSID
|
INTEGER
|
System identifier for the large object directory in the databank. |
Primary key: DATABANK_SYSID, DATABANK_SEQNO, DATABANK_FILENO
Unique constraint: SHADOW_NAME, DATABANK_FILENO
Unique constraint: DATABANK_FILENAME
Secondary index: DATABANK_NAME, DATABANK_SEQNO
DOMAINS
Records the domains in the database.
Column name
|
Data type
|
Description
|
DOMAIN_SYSID
|
INTEGER
|
System identifier for the domain. |
CHARSET_SYSID
|
INTEGER
|
System identifier for the character set. |
COLLATION_SYSID
|
INTEGER
|
System identifier for the collation for a domain associated with a character set. |
DATA_TYPE
|
CHAR(30)
|
Identifies the data type of the domain.
Can be one of the following:
BIGINT
BINARY
BINARY VARYING
BINARY LARGE OBJECT
CHARACTER
CHARACTER LARGE OBJECT
NATIONAL CHARACTER
NATIONAL CHARACTER VARYING
CHARACTER VARYING
DATE
DECIMAL
DOUBLE PRECISION
FLOAT
Float(p)
INTEGER
Integer(p)
INTERVAL
NUMERIC
REAL
SMALLINT
TIME
TIMESTAMP. |
INTERVAL_TYPE
|
CHAR(30)
|
For INTERVAL data types, this is a character string specifying the interval qualifier for the named interval data type, see the Mimer SQL Reference Manual. For other data types it is the NULL value. |
CHAR_MAX_LENGTH
|
BIGINT
|
For CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in characters or bytes as appropriate. For all other data types it is the NULL value. |
CHAR_OCTET_LENGTH
|
BIGINT
|
For a CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in octets. For all other data types it is the NULL value. (For single octet character sets, this is the same as CHAR_MAX_LENGTH.) |
NUMERIC_PRECISION
|
INTEGER
|
For NUMERIC data types, this shows the total number of decimal digits allowed in the column. For all other data types it is the NULL value. NUMERIC_PREC_RADIX indicates the units of measurement. |
NUMERIC_SCALE
|
INTEGER
|
This defines the total number of significant digits to the right of the decimal point. For INTEGER and SMALLINT, this is 0. For CHARACTER, VARCHAR, DATETIME, FLOAT, INTERVAL, REAL and DOUBLE PRECISION data types, it is the NULL value. |
NUMERIC_PREC_RADIX
|
INTEGER
|
For NUMERIC data types, the value 10 is shown because NUMERIC_PRECISION specifies a number of decimal digits. For all other data types it is the NULL value. NUMERIC_PRECISION and NUMERIC_PREC_RADIX can be combined to calculate the maximum number that the column can hold. |
DATETIME_PRECISION
|
INTEGER
|
For DATE, TIME, TIMESTAMP and interval data types, this column contains the number of digits of precision for the fractional seconds component. For other data types it is the NULL value. |
INTERVAL_PRECISION
|
INTEGER
|
For INTERVAL data types, this is the number of significant digits for the interval leading precision, see the Mimer SQL Reference Manual.
For other data types it is the NULL value.
|
INTERNAL_LENGTH
|
INTEGER
|
Internal length in bytes of value. |
DOMAIN_DEFAULT
|
NATIONAL VARCHAR(400)
|
This shows the default value for the domain.
If the default value is a character string, the value shown is the string enclosed in single quotes.
If the default value is a numeric literal, the value is shown in its original character representation without enclosing quotes.
If the default value is a DATE, TIME or TIMESTAMP, the value shown is the appropriate keyword (e.g. DATE) followed by the literal representation of the value enclosed in single quotes, see Mimer SQL Reference Manual for a description of DATE, TIME and TIMESTAMP literals.
If the default value is a pseudo-literal, the value shown is the appropriate keyword (e.g. CURRENT_DATE) without enclosing quotes.
If the default value is the NULL value, the value shown is the keyword NULL without enclosing quotes.
If the default value cannot be represented without truncation, then a zero-length string is stored.
If no default value was specified then its value is the NULL value.
The value of DOMAIN_DEFAULT is syntactically suitable for use in specifying default-value in a CREATE TABLE or ALTER TABLE statement.
|
ANY_CONSTRAINT
|
CHAR(3)
|
One of:
NO = There are no constraints for the domain
YES = There are constraints for the domain. |
IS_LEVEL2_APPROVED
|
CHAR(3)
|
One of:
NO = Tables using this domain can not be used with the level 2 interface
YES = The use of this domain does not prohibit the table being used with the level 2 interface. |
Primary key: DOMAIN_SYSID
DOMAIN_CONSTRAINTS
Records the constraints defined for domains in the database.
.
Column name
|
Data type
|
Description
|
DOMAIN_SYSID
|
INTEGER
|
System identifier for the domain. |
CONSTRAINT_SYSID
|
INTEGER
|
System identifier for the constraint. |
IS_DEFERRABLE
|
CHAR(3)
|
One of:
NO = the constraint is not deferrable.
YES = the constraint is deferrable. |
INITIALLY_DEFERRED
|
CHAR(3)
|
One of:
NO = the constraint is not initially deferred
YES = the constraint is initially deferred. |
Primary key: DOMAIN_SYSID, CONSTRAINT_SYSID
EXEC_STATEMENTS
Records precompiled statements in the database.
Column name
|
Data type
|
Description
|
STATEMENT_SYSID
|
INTEGER
|
System identifier for the precompiled statement. |
STATEMENT_TYPE
|
INTEGER
|
Type of statement (internal value). |
STATEMENT_SOURCE
|
NATIONAL VARCHAR(400)
|
Source text for the precompiled statement. If the length exceeds 400 characters, this value is NULL and the source text is stored in SOURCE_DEFINITION. |
STATEMENT_SOU_LENGTH
|
CHAR(3)
|
Length of source text in characters. |
FIPS_FEATURES
Lists details of all FIPS features.
Column name
|
Data type
|
Description
|
FEATURE_ID
|
SMALLINT
|
Identification number of the FIPS feature. |
FEATURE_NAME
|
CHAR(50)
|
The name of the FIPS feature. |
CLASSIFICATION
|
CHAR(12)
|
The conformance level of the feature.
One of:
TRANSITIONAL
INTERMEDIATE
FULL. |
IS_SUPPORTED
|
CHAR(3)
|
One of:
YES = Mimer SQL supports the feature
NO = Mimer SQL does not support the feature. |
IS_VERIFIED
|
CHAR(3)
|
One of:
YES = Mimer SQL support for the feature has been tested and verified
NO = Mimer SQL support for the feature has not been verified. |
FEATURE_COMMENTS
|
VARCHAR(500)
|
Comments about the feature. |
Primary key: FEATURE_ID
FIPS_SIZING
Lists details about FIPS limits.
Column name
|
Data type
|
Description
|
SIZING_ID
|
SMALLINT
|
Identification number for limit. |
DESCRIPTION
|
CHAR(50)
|
Description of limit. |
ENTRY_VALUE
|
INTEGER
|
Limit for entry SQL. |
INTERMEDIATE_VALUE
|
INTEGER
|
Limit for intermediate SQL. |
VALUE_SUPPORTED
|
INTEGER
|
Limit for Mimer SQL. |
SIZING_COMMENTS
|
VARCHAR(500)
|
Comments for limit. |
Primary key: SIZING_ID
KEY_COLUMN_USAGE
Records columns in an index or in a primary, unique or foreign key.
Column name
|
Data type
|
Description
|
TABLE_SYSID
|
INTEGER
|
System identifier for the table. |
CONSTRAINT_SYSID
|
INTEGER
|
System identifier for the table constraint. |
ORDINAL_POSITION
|
INTEGER
|
The ordinal position of the column in the table. The first column in the table is number 1. |
COLUMN_NAME
|
VARCHAR(128)
|
The name of the table column. |
KEY_TYPE
|
CHAR(20)
|
One of:
PRIMARY_KEY
UNIQUE
FOREIGN_KEY
INDEX
INTERNAL_KEY. |
IS_UNIQUE
|
CHAR(3)
|
One of:
NO = the column may contain non-unique values
YES = the column is constrained to contain only unique values. |
IS_ASCENDING
|
CHAR(3)
|
One of: NO = the column is indexed in descending value order
YES = the column is indexed in ascending value order. |
COLLATION_SYSID
|
INTEGER
|
System identifier for the collation used by the index. |
Primary key: TABLE_SYSID, CONSTRAINT_SYSID, ORDINAL_POSITION
Unique constraint: CONSTRAINT_SYSID, COLUMN_NAME
LEVEL2_RESTRICT
Records restrictions for domains legal for use by DB level 2.
Column name
|
Data type
|
Description
|
DOMAINID
|
INT(10)
|
System identifier for the domain with restrictions. |
SEQNO
|
INT(3)
|
Restriction order number. |
LOGOP
|
CHAR(3)
|
Logical operator (AND, OR). |
RELOP
|
CHAR(2)
|
Relational operator (EQ, ...). |
LENGTH
|
INT(5)
|
Length of the value. |
RESVALUE
|
CHAR(64)
|
Restriction value. |
Primary key: DOMAINID, SEQNO
LEVEL2_VIEWCOL
Records columns of views acceptable by DB level 2.
Column name
|
Data type
|
Description
|
VTABID
|
INT(10)
|
View table identifier. |
VCOLNO
|
INT(3)
|
View table column number. |
BTABID
|
INT(10)
|
Base table identifier. |
BCOLNO
|
INT(3)
|
Base table column number. |
Primary key: VTABID, VCOLNO
LEVEL2_VIEWRES
Records restrictions for DB level 2.
Column name
|
Data type
|
Description
|
VTABID
|
INT(10)
|
View table identifier. |
SEQNO
|
INT(3)
|
Restriction order number. |
LOGOP
|
CHAR(3)
|
Logical operator (AND, OR). |
BTABID
|
INT(10)
|
Base table identifier. |
BCOLNO
|
INT(3)
|
Base table column number. |
RELOP
|
CHAR(2)
|
Relational operator (EQ, ...). |
LENGTH
|
INT(5)
|
Length of the value. |
RESVALUE
|
CHAR(64)
|
Restriction value. |
Primary key: VTABID, SEQNO
MANYROWS
Dummy table with more than row.
Column name
|
Data type
|
Description
|
C
|
INT(3)
|
The values column. |
Primary key: C
MESSAGE
Records translations of message codes to message text.
Column name
|
Data type
|
Description
|
MODULEID
|
INTEGER
|
Identification number for Mimer SQL module to which error belongs. |
MESSAGEID
|
INTEGER
|
Identification number for message |
LANGUAGE
|
INTEGER
|
Language number for message
1 = English. |
LINENO
|
INTEGER
|
Line number for message. |
MESSAGE
|
CHAR(80)
|
Message text. |
Primary key: MODULEID, MESSAGEID, LANGUAGE, LINENO
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
|
NATIONAL VARCHAR(400)
|
Source text for module definition, if the length of the module definition exceeds 400 characters, this value is NULL and the source text is stored in SOURCE_DEFINITION. |
SQL_PATH
|
VARCHAR(1000)
|
The path for the module. |
Primary key: MODULE_SYSID
OBJECTS
Records objects in the database.
Column name
|
Data type
|
Description
|
OBJECT_SYSID
|
INTEGER
|
System identifier for the database object. |
OBJECT_TYPE
|
CHAR(20)
|
One of:
BASE TABLE
CHARACTER SET
COLLATION
CONSTRAINT
DATABANK
DOMAIN
FUNCTION
INDEX
IDENT
MODULE
PROCEDURE
SCHEMA
SEQUENCE
SHADOW
STATEMENT
SYNONYM
TRANSLATION
TRIGGER
VIEW. |
OBJECT_SCHEMA
|
VARCHAR(128)
|
The name of the schema containing the object. |
OBJECT_NAME
|
VARCHAR(128)
|
The name of the object. |
OBJECT_CREATED
|
TIMESTAMP(2)
|
The date and time the object was created. |
OBJECT_ALTERED
|
TIMESTAMP(2)
|
The date and time the object was last altered. |
REMARKS
|
NATIONAL VARCHAR(254)
|
Comments defined on the object. If there is no comment defined the empty string ("") will appear. Remarks relating to columns will be stored in the COLUMNS table. |
Primary key: OBJECT_SYSID
Unique constraint: OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME
OBJECT_COLUMN_USE
Records columns referenced by other database objects.
Column name
|
Data type
|
Description
|
TABLE_SYSID
|
INTEGER
|
System identifier for the table. |
COLUMN_NAME
|
VARCHAR(128)
|
The name of the table column. |
USED_BY_SYSID
|
INTEGER
|
The system identifier of the referencing object. |
USED_BY_TYPE
|
CHAR(20)
|
One of:
VIEW
PROCEDURE
FUNCTION
CHECK
TRIGGER
STATEMENT. |
PRIVILEGE_TYPE
|
CHAR(20)
|
One of:
INSERT
DELETE
SELECT
UPDATE
REFERENCES. |
Primary key: TABLE_SYSID, COLUMN_NAME, USED_BY_SYSID, USED_BY_TYPE, PRIVILEGE_TYPE
Secondary index: USED_BY_SYSID, USED_BY_TYPE
OBJECT_OBJECT_USE
Records objects referenced by other objects.
Column name
|
Data type
|
Description
|
OBJECT_SYSID
|
INTEGER
|
System identifier for the object used. |
OBJECT_TYPE
|
CHAR(20)
|
One of:
BASE TABLE
VIEW
PROCEDURE
FUNCTION
DOMAIN
SEQUENCE
CHARACTER SET
COLLATION
TRANSLATION. |
USED_BY_SYSID
|
INTEGER
|
The system identifier of the referencing object. |
USED_BY_TYPE
|
CHAR(20)
|
One of:
BASE_TABLE
VIEW
PROCEDURE
FUNCTION
DOMAIN
TRIGGER
CHARACTER SET
COLLATION
TRANSLATION
CHECK
INDEX
STATEMENT. |
Primary key: OBJECT_SYSID, OBJECT_TYPE, USED_BY_SYSID, USED_BY_TYPE
Secondary index: USED_BY_SYSID, USED_BY_TYPE
ONEROW
Dummy table containing one row.
Column name
|
Data type
|
Description
|
M
|
CHAR(1)
|
Contains the value M. |
Primary key: M
PARAMETERS
Records parameters of routines in the database.
Column name
|
Data type
|
Description
|
ROUTINE_SYSID
|
INTEGER
|
System identifier for the function or procedure. |
ORDINAL_POSITION
|
INTEGER
|
The ordinal position of the parameter in the routine. The first parameter in the routine is number 1. |
IS_RESULT
|
CHAR(3)
|
One of:
NO = This parameter is not part of the result clause for a result set procedure
YES = This parameter is part of the result set. |
PARAMETER_MODE
|
CHAR(5)
|
One of:
IN
OUT
INOUT. |
PARAMETER_NAME
|
VARCHAR(128)
|
The name of the parameter. |
DOMAIN_SYSID
|
INTEGER
|
System identifier of the domain that defines the data type of the parameter. |
COLLATION_SYSID
|
INTEGER
|
System identifier of the collation associated with the parameter. |
CHARSET_SYSID
|
INTEGER
|
The system identifier for the character set. |
UDT_SYSID
|
INTEGER
|
System identifier for a user-defined type. |
DATA_TYPE
|
CHAR(30)
|
The data type of the parameter. |
INTERVAL_TYPE
|
CHAR(30)
|
For INTERVAL data types, this is a character string specifying the interval qualifier for the named interval data type, see the Mimer SQL Reference Manual. For other data types it is the NULL value. |
CHAR_MAX_LENGTH
|
BIGINT
|
For CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in characters or bytes as appropriate. For all other data types it is the NULL value. |
CHAR_OCTET_LENGTH
|
BIGINT
|
For a CHARACTER, BINARY, CHARACTER LARGE OBJECT and BINARY LARGE OBJECT data types, this shows the maximum length in octets. For all other data types it is the NULL value. (For single octet character sets, this is the same as CHAR_MAX_LENGTH.) |
NUMERIC_PRECISION
|
INTEGER
|
For NUMERIC data types, this shows the total number of decimal digits allowed in the column. For all other data types it is the NULL value. NUMERIC_PREC_RADIX indicates the units of measurement. |
NUMERIC_SCALE
|
INTEGER
|
This defines the total number of significant digits to the right of the decimal point. For INTEGER and SMALLINT, this is 0. For CHARACTER, VARCHAR, DATETIME, FLOAT, INTERVAL, REAL and DOUBLE PRECISION data types, it is the NULL value. |
NUMERIC_PREC_RADIX
|
INTEGER
|
For numeric data types, the value 10 is shown because NUMERIC_PRECISION specifies a number of decimal digits. For all other data types it is the NULL value. NUMERIC_PRECISION and NUMERIC_PREC_RADIX can be combined to calculate the maximum number that the column can hold. |
DATETIME_PRECISION
|
INTEGER
|
For DATE, TIME, TIMESTAMP and INTERVAL data types, this column contains the number of digits of precision for the fractional seconds component. For other data types it is the NULL value. |
INTERVAL_PRECISION
|
INTEGER
|
For INTERVAL data types, this is the number of significant digits for the interval leading precision, see the Mimer SQL Reference Manual. For other data types it is the NULL value. |
Primary key: ROUTINE_SYSID, ORDINAL_POSITION, IS_RESULT
REFER_CONSTRAINTS
Records referential constraints in the database.
Column name
|
Data type
|
Description
|
TABLE_SYSID
|
INTEGER
|
System identifier for the table. |
CONSTRAINT_SYSID
|
INTEGER
|
System identifier for the referential constraint. |
UNIQUE_TABLE_SYSID
|
INTEGER
|
System identifier for the table that is referenced in the foreign key. |
UNIQUE_CONST_SYSID
|
INTEGER
|
System identifier for the constraint that is (implicitly) referenced in the foreign key. |
MATCH_OPTION
|
CHAR(20)
|
One of:
NONE
PARTIAL
FULL. |
UPDATE_RULE
|
CHAR(20)
|
One of:
CASCADE
SET NULL
SET DEFAULT
NO ACTION
RESTRICT. |
DELETE_RULE
|
CHAR(20)
|
One of:
CASCADE
SET NULL
SET DEFAULT
NO ACTION
RESTRICT. |
Primary key: TABLE_SYSID, CONSTRAINT_SYSID
Secondary index: UNIQUE_TABLE_SYSID, UNIQUE_CONST_SYSID
ROUTINES
Records procedures and user-defined functions in the database.
Column name
|
Data type
|
Description
|
ROUTINE_SYSID
|
INTEGER
|
System identifier of the function or procedure. |
MODULE_SYSID
|
INTEGER
|
System identifier of the module to which the routine belongs. |
ROUTINE_TYPE
|
CHAR(20)
|
One of:
PROCEDURE
FUNCTION. |
SQL_DATA_ACCESS
|
CHAR(20)
|
One of:
NO SQL
CONTAINS SQL
READS SQL DATA
MODIFIES SQL DATA. |
ROUTINE_OFFSET
|
INTEGER
|
Offset for routine within module definition. This value is zero if the routine ins not defined in a module. |
ROUTINE_LENGTH
|
INTEGER
|
Length of routine definition |
TOTAL_PARAMS
|
INTEGER
|
The total number of routine parameters. |
RESULT_PARAMS
|
INTEGER
|
The number of result parameters. |
INPUT_PARAMS
|
INTEGER
|
The number of input parameters. |
OUTPUT_PARAMS
|
INTEGER
|
The number of output parameters. |
ROUTINE_DEFINITION
|
NATIONAL VARCHAR(400)
|
Routine definition. If the length of the routine definition exceeds 400 characters, this value is NULL and the source text is stored in SOURCE_DEFINITION. |
SQL_PATH
|
VARCHAR(1000)
|
The search path for the routine. |
IS_DETERMINISTIC
|
CHAR(3)
|
One of:
NO = The routine is not deterministic. i.e. invoking the routine with the same input values is not guaranteed to return the same result
YES = The routine is deterministic, i.e. when invoked with same input values it will always return the same result. |
ROUTINE_BODY
|
CHAR(20)
|
One of:
SQL = The routine is a SQL routine
EXTERNAL = The routine is external |
EXTERNAL_NAME
|
VARCHAR(128)
|
The name of the program that implements the routine if it is an external routine otherwise null. |
EXTERNAL_LANGUAGE
|
CHAR(20)
|
The language for the routine if it is external otherwise null. |
PARAMETER_STYLE
|
CHAR(20)
|
The parameter passing style for the routine if it is an external routine, otherwise null. |
SCHEMA_LEVEL_ROU
|
CHAR(3)
|
One of:
NO = The routine is defined within a module
YES = The routine is not defined in a module. |
MX_DYN_RESULT_SETS
|
INTEGER
|
The maximal number of result sets that the routine may return. |
Primary key: ROUTINE_SYSID
Secondary index: MODULE_SYSID
SCHEMATA
Records schemas in the database.
Column name
|
Data type
|
Description
|
SCHEMA_SYSID
|
INTEGER
|
System identifier of the schema. |
DEF_CHARSET_SYSID
|
INTEGER
|
System identifier of the default character set. |
SQL_PATH
|
VARCHAR(1000)
|
The default search path for objects belonging to the schema. |
Primary key: SCHEMA_SYSID
SEQUENCES
Records sequences in the database.
Column name
|
Data type
|
Description
|
SEQUENCE_SYSID
|
INTEGER
|
System identifier of the sequence. |
IS_UNIQUE
|
CHAR(3)
|
One of:
YES = the sequence will yield unique values
NO = the sequence may repeat itself. |
START_VALUE
|
INTEGER
|
The initial value of the sequence. |
CURRENT_VALUE
|
INTEGER
|
The current value of the sequence. |
MAX_VALUE
|
INTEGER
|
The maximum value of the sequence. |
INCREMENT_VALUE
|
INTEGER
|
The increment value of sequence. |
IS_EXHAUSTED
|
CHAR(3)
|
One of:
YES = the series of values defined by the sequence is exhausted
NO = the series of values defined by the sequence is not exhausted. |
CYCLES
|
INTEGER
|
Number of times the maximum value of the sequence is exceeded. |
Primary key: SEQUENCE_SYSID
SERVER_INFO
Records attributes of the current database system or server.
Column name
|
Data type
|
Description
|
SERVER_ATTRIBUTE
|
VARCHAR(254)
|
One of:
CATALOG_NAME
COLLATION_SEQ
IDENTIFIER_LENGTH
INTERVAL_FRAC_PREC
INTERVAL_LEAD_PREC
ROW_LENGTH
TIME_PREC
TIMESTAMP_PREC
TXN_ISOLATION
USERID_LENGTH
CATALOG_VERSION_CREATED
CATALOG_VERSION_CURRENT. |
ATTRIBUTE_VALUE
|
VARCHAR(254)
|
The value for the attribute. |
Primary key: SERVER_ATTRIBUTE
SEVERITY
Records severity levels and optional module for error codes.
Column name
|
Data type
|
Description
|
MODULEID
|
INTEGER
|
Identification number for the Mimer SQL module to which the message belongs. |
MESSAGEID
|
INTEGER
|
Identification number for message. |
SEVERITY
|
INTEGER
|
Severity for message:
1 = Message
2 = Warning
3 = Error
4 = Fatal error
5 = Internal error
6 = Code. |
MODULE
|
CHAR(20)
|
Name of Mimer SQL module to which the message belongs. |
SQLSTATE_VALUE
|
CHAR(5)
|
Corresponding SQLSTATE value for message. |
CLASS_ORIGIN
|
CHAR(20)
|
Class origin for the SQLSTATE value. |
SUBCLASS_ORIGIN
|
CHAR(20)
|
Sub class origin for the SQLSTATE value. |
Primary key: MODULEID, MESSAGEID
SOURCE_DEFINITION
Records source definitions for defaults, check constraints, views, modules, procedures, functions, triggers and statements.
Column name
|
Data type
|
Description
|
SOURCE_SYSID
|
INTEGER
|
System identifier of the source definition. |
COLUMN_NAME
|
VARCHAR(128)
|
Column name if the source types is a default value for a column. |
SOURCE_TYPE
|
CHAR(20)
|
One of:
DEFAULT
CHECK
VIEW
ROUTINE
STATEMENT. |
SEQUENCE_NO
|
INTEGER
|
Sequence number in source definition. |
SOURCE_LENGTH
|
INTEGER
|
The length of the stored source text. |
SOURCE_DEFINITION
|
NATIONAL VARCHAR(800)
|
The stored source text. |
Primary key: SOURCE_SYSID, COLUMN_NAME, SEQUENCE_NO
SPECIFIC_NAMES
Records specific names of the routines in the database.
Column name
|
Data type
|
Description
|
ROUTINE_SYSID
|
INTEGER
|
System identifier of the routine. |
SPECIFIC_SCHEMA
|
VARCHAR(128)
|
The name of the schema containing the routine. |
SPECIFIC_NAME
|
VARCHAR(128)
|
The specific name for the routine. |
Primary key: ROUTINE_SYSID
SQL_LANGUAGES
Records the SQL standards and SQL dialects supported.
Column name
|
Data type
|
Description
|
SOURCE
|
VARCHAR(254)
|
Body that has defined standard. |
SOURCE_YEAR
|
VARCHAR(254)
|
Which year the standard was approved. |
CONFORMANCE
|
VARCHAR(254)
|
Level of conformance within standard. |
INTEGRITY
|
VARCHAR(254)
|
If the supported standard is ISO 9075 the value YES in this column means that the integrity enhancement feature of this standard is supported, otherwise the value of this column is null. |
IMPLEMENTATION
|
VARCHAR(254)
|
Implementation style, always null in Mimer SQL. |
BINDING_STYLE
|
VARCHAR(254)
|
One of:
DIRECT = Support for interactive (ad hoc) access to the database
EMBEDDED = Support for access through an application programming interface. |
PROGRAMMING_LANG
|
VARCHAR(254)
|
Name of programming languages that are supported if the binding style is EMBEDDED. |
Primary key: SOURCE, SOURCE_YEAR
STATEMENT_DESCRIPTORS
Records compiled code for precompiled statements.
Column name
|
Data type
|
Description
|
STATEMENT_SYSID
|
INTEGER
|
System identifier for the precompiled statement. |
DESC_MODE
|
INTEGER
|
Mode, one of:
1 = no scroll
2 = scroll |
DESC_TYPE
|
INTEGER
|
Internal. Naming or section descriptor type. |
DESC_SEQNO
|
INTEGER
|
Sequence number for compiled code. |
DESC_CODE_LENGTH
|
INTEGER
|
Length of compiled code. |
DESC_CODE
|
BINARY(1000)
|
Compiled code. |
DESC_VERSION
|
INTEGER
|
Compiler version used. |
STATEMENT_ROUTINE_USE
Records compiled routines used by precompiled statements.
Column name
|
Data type
|
Description
|
STATEMENT_SYSID
|
INTEGER
|
System identifier for the precompiled statement. |
USE_SEQNO
|
INTEGER
|
Sequence number. |
USE_LEVEL
|
INTEGER
|
Call level for routine. |
USE_ROUTINE_SYSID
|
INTEGER
|
System identifier for called routines. |
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
TABLES
Records tables and views in the database.
Column name
|
Data type
|
Description
|
TABLE_SYSID
|
INTEGER
|
System identifier of the table or view. |
TABLE_TYPE
|
CHAR(20)
|
One of:
BASE TABLE
VIEW. |
TABLE_NOCOLS
|
INTEGER
|
Number of columns in table. |
TABLE_RECLEN
|
INTEGER
|
Record length for table. |
TABLE_CARD
|
BIGINT
|
Number of records in table. |
STATISTIC_GATHERED
|
TIMESTAMP(2)
|
Date and time when statistics for the table or view were lasted updated. |
IS_LEVEL2_APPROVED
|
CHAR(3)
|
One of:
YES = The table can be used with level 2 DB interface.
NO = The table cannot be used with level 2 DB interface. |
IS_PERSISTENT
|
CHAR(3)
|
One of:
NO = The table is a temporary table
YES = The table is not temporary. |
DATABANK_SYSID
|
INTEGER
|
System identifier of the databank in which the table is stored. |
Primary key: TABLE_SYSID
Secondary index: DATABANK_SYSID
TABLE_CONSTRAINTS
Records table constraints in the database.
Column name
|
Data type
|
Description
|
TABLE_SYSID
|
INTEGER
|
System identifier of the table. |
CONSTRAINT_TYPE
|
CHAR(20)
|
One of:
PRIMARY KEY
UNIQUE
FOREIGN KEY
INDEX
INDEX UNIQUE
INTERNAL KEY
CHECK. |
CONSTRAINT_SYSID
|
INTEGER
|
System identifier of the constraint. |
CONSTRAINT_KEYCOLS
|
INTEGER
|
Number of key columns in the constraint. |
CONSTRAINT_KEYLEN
|
INTEGER
|
Record length for key columns in the constraint. |
CONSTRAINT_RECCOLS
|
INTEGER
|
Number of columns in constraint. |
CONSTRAINT_RECLEN
|
INTEGER
|
Record length for constraint. |
CONSTRAINT_CARD
|
BIGINT
|
Number of records in constraint. |
DATABANK_SYSID
|
INTEGER
|
System identifier of the databank in which the table is stored. |
IS_CONSISTENT
|
CHAR(3)
|
One of:
NO = The index may be inconsistent and should not be used for index lookup only
YES = The index may be used for index lookup only. |
IS_DEFERRABLE
|
CHAR(3)
|
One of:
NO = The constraint is not deferrable
YES = The constraint is deferrable. |
INITIALLY_DEFERRED
|
CHAR(3)
|
One of:
NO = The constraint is immediate
YES = The constraint is not immediate. |
Primary key: TABLE_SYSID, CONSTRAINT_TYPE, CONSTRAINT_SYSID
Unique constraint: CONSTRAINT_SYSID
TABLE_PRIVILEGES
Records instances of privileges granted on a table.
Column name
|
Data type
|
Description
|
TABLE_SYSID
|
INTEGER
|
System identifier of the table. |
PRIVILEGE_TYPE
|
CHAR(20)
|
One of:
DELETE
INSERT
LOAD
REFERENCES
SELECT
UPDATE
TRIGGER. |
GRANTEE
|
VARCHAR(128)
|
The name of the ident to whom the table privilege was granted. |
GRANTOR
|
VARCHAR(128)
|
The name of the ident granting the table privilege. |
IS_GRANTABLE
|
CHAR(3)
|
One of:
YES = WITH GRANT OPTION is held with the privilege
NO = WITH GRANT OPTION is not held with the privilege. |
IS_INSTEAD_OF
|
CHAR(3)
|
One of:
NO = The privilege was granted explicitly
YES = The privilege was granted implicitly when an instead of trigger was created. |
IS_ON_TABLE
|
CHAR(3)
|
One of:
NO = The privilege was granted on individual columns
YES = The privilege was granted on the complete table. |
ALL_COLUMNS
|
CHAR(3)
|
One of:
YES = the privilege was granted on the table and therefore applies to all table columns, including new ones added
NO = the privilege only applies to the table columns explicitly specified when the privilege was granted. |
Primary key: TABLE_SYSID, PRIVILEGE_TYPE, GRANTEE, GRANTOR
Secondary index: GRANTEE
Secondary index: GRANTOR
TABLE_TYPES
Records the types of table supported.
Column name
|
Data type
|
Description
|
TABLE_TYPE
|
CHAR(20)
|
One of:
SYNONYM
SYSTEM TABLE
TABLE
VIEW. |
Primary key: TABLE_TYPE
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
TRIGGERED_COLUMNS
Records table columns explicitly specified in an UPDATE TRIGGER event.
Column name
|
Data type
|
Description
|
TRIGGER_SYSID
|
INTEGER
|
System identifier of the trigger. |
EVENT_TABLE_SYSID
|
INTEGER
|
System identifier of the table on which the trigger is defined. |
EVENT_COLUMN_NAME
|
VARCHAR(128)
|
The name of the column in which updates will cause the trigger to execute. |
Primary key: TRIGGER_SYSID, EVENT_TABLE_SYSID, EVENT_COLUMN_NAME
TRIGGERS
Records triggers in the database.
Column name
|
Data type
|
Description
|
TRIGGER_SYSID
|
INTEGER
|
System identifier of the trigger. |
EVENT_TABLE_SYSID
|
INTEGER
|
System identifier of the table on which the trigger is defined. |
EVENT_MANIPULATION
|
CHAR(20)
|
One of:
DELETE
INSERT
UPDATE. |
ACTION_ORDER
|
INTEGER
|
Ordinal number for trigger execution. This number will define the execution order of triggers on the same table and with the same value for EVENT_MANIPULATION, ACTION_CONDITION, CONDITION_TIMING and ACTION_ORIENTATION. The trigger with 1 in this column will be executed first, followed by the trigger with 2 etc. |
ACTION_CONDITION
|
NATIONAL VARCHAR(400)
|
The text of the search condition of the trigger action WHEN clause. |
ACTION_STATEMENT
|
NATIONAL VARCHAR(400)
|
The character representation of the body of the trigger. If the length of the text exceeds 400 characters, this value is NULL and the source text is stored in SOURCE_DEFINITION. |
ACTION_ORIENTATION
|
CHAR(20)
|
One of:
ROW
STATEMENT. |
CONDITION_TIMING
|
CHAR(20)
|
One of:
BEFORE
AFTER
INSTEAD OF. |
COND_REF_NEW_TABLE
|
VARCHAR(128)
|
Name of new table/row alias. |
COND_REF_OLD_TABLE
|
VARCHAR(128)
|
Name of old table/row alias. |
REFERENCE_NEW
|
CHAR(3)
|
One of:
NO = The trigger has no new table/row alias
YES = The trigger has new table/row alias. |
REFERENCE_OLD
|
CHAR(3)
|
One of:
NO = The trigger has no new table/row alias
YES = The trigger has new table/row alias. |
COLS_IS_IMPLICIT
|
CHAR(3)
|
One of:
NO = The trigger is invoked on update on any column (if the event is update)
YES = The trigger will only be invoked if a column in the for update of list is updated. |
REF_SYSID
|
INTEGER
|
System identifier for foreign key constraint, if the trigger is defined for checking of a delete rule. |
Primary key: TRIGGER_SYSID
Secondary index: EVENT_TABLE_SYSID
TYPE_INFO
Records information about data types supported.
Column name
|
Data type
|
Description
|
DATA_TYPE
|
SMALLINT
|
Identification number for data type. |
TYPE_NAME
|
CHAR(30)
|
Name of data type. |
COLUMN_SIZE
|
INTEGER
|
Length of data type name. |
LITERAL_PREFIX
|
CHAR(30)
|
Optional prefix for a literal of this type. |
LITERAL_SUFFIX
|
CHAR(30)
|
Optional suffix for a literal of this type. |
CREATE_PARAMS
|
CHAR(30)
|
A description of how to specify length attributes for the data type. |
NULLABLE
|
SMALLINT
|
One of:
1 = A not null constraint can be used with this type in a domain or column definition
0 = A not null constraint can not be used with this type in a domain or column definition. |
CASE_SENSITIVE
|
SMALLINT
|
One of:
1 = The data type name is case sensitive
0 = The data type name is not case sensitive. |
SEARCHABLE
|
SMALLINT
|
One of:
3 = The data type can be used with any comparison operator
2 = The data type can be used with any comparison operator except like
1 = The data type can only be used with the LIKE operator
0 = The data type can not be used with any comparison operator. |
UNSIGNED_ATTRIBUTE
|
SMALLINT
|
One of:
1 = The data type is unsigned
0 = The data type is signed
The value is NULL if the data type is non-numeric. |
FIXED_PREC_SCALE
|
SMALLINT
|
One of:
1 = The data type has a determined precision and scale
0 = The data type does not have a determined precision and scale. |
AUTO_UNIQUE_VALUE
|
SMALLINT
|
One of:
1 = The data type will generate unique values
0 = The data type will not generate unique values. |
LOCAL_TYPE_NAME
|
CHAR(30)
|
Local name for data type. |
MINIMUM_SCALE
|
SMALLINT
|
Minimum value for scale for a numeric data type. |
MAXIMUM_SCALE
|
SMALLINT
|
Maximum value for scale for a numeric data type. |
SQL_DATA_TYPE
|
SMALLINT
|
A numeric value representing the data type. |
SQL_DATETIME_SUB
|
SMALLINT
|
Sub type for an interval data type. |
NUM_PREC_RADIX
|
SMALLINT
|
Radix for numeric data type. |
INTERVAL_PRECISION
|
SMALLINT
|
Precision for an interval data type. |
PRECISION
|
INTEGER
|
Precision for data type. |
INTERNAL_LEN_DIFF
|
SMALLINT
|
Internal length difference. |
INTERNAL_TYPENAME
|
CHAR(30)
|
Internal type name. |
INTERNAL_VERSION
|
SMALLINT
|
Internal version number. |
INTERNAL_TYPEORDER
|
SMALLINT
|
Internal type ordering number. |
Primary key: DATA_TYPE, TYPE_NAME
USAGE_PRIVILEGES
Records instances of privileges which grant the right to use a database object.
Column name
|
Data type
|
Description
|
OBJECT_SYSID
|
INTEGER
|
System identifier of the database object. |
OBJECT_PRIVILEGE
|
CHAR(20)
|
One of:
BACKUP
CHARACTER SET
COLLATION
DATABANK
DOMAIN
FUNCTION
IDENT
MEMBER
MODULE
PROCEDURE
PROGRAM
SCHEMA
SEQUENCE
SHADOW
STATISTICS
STATEMENT
TABLE
TRANSLATION. |
GRANTEE
|
VARCHAR(128)
|
The name of the ident to whom the usage privilege was granted. |
GRANTOR
|
VARCHAR(128)
|
The name of the ident granting the usage privilege. |
IS_GRANTABLE
|
CHAR(3)
|
One of:
YES = WITH GRANT OPTION is held with the privilege
NO = WITH GRANT OPTION is not held with the privilege. |
Primary key: OBJECT_SYSID, OBJECT_PRIVILEGE, GRANTEE, GRANTOR
Secondary index: GRANTEE
Secondary index: GRANTOR
USERS
Records idents (GROUP, OS_USER, PROGRAM or USER) in the database.
Column name
|
Data type
|
Description
|
USER_NAME
|
VARCHAR(128)
|
The ident name. |
USER_SYSID
|
INTEGER
|
System identifier for the ident. |
USER_TYPE
|
CHAR(20)
|
One of:
USER
OS_USER
PROGRAM
GROUP. |
USER_PASSWORD
|
BINARY(18)
|
The encoded password for the ident. |
USER_PASSWORD
_MINIMUM_LENGTH
|
INTEGER
|
The minimum length for a password. |
Primary key: USER_NAME
Unique constraint: USER_SYSID
VIEWS
Records views in the database.
Column name
|
Data type
|
Description
|
VIEW_SYSID
|
INTEGER
|
System identifier of the view. |
CHECK_OPTION
|
CHAR(20)
|
One of:
CASCADED
LOCAL
NONE. |
IS_UPDATABLE
|
CHAR(3)
|
One of:
NO = The view can not be updated
YES = The view can be updated. |
IS_INSTEAD_OF
|
CHAR(3)
|
One of:
NO = The view can be updated per se
YES = The view can be updated due to the existence of an instead of trigger. |
VIEW_DEFINITION
|
NATIONAL VARCHAR(400)
|
The text of the view definition. |
Primary key: VIEW_SYSID
