Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


FIPS_DOCUMENTATION


The table below summarizes the system views that are part of the schema FIPS_DOCUMENTATION (view names appear in their unqualified form):

View name
Description
SQL_FEATURES
Lists each FIPS feature with details about Mimer SQL compliance.
SQL_SIZING
For each FIPS database construct, lists the minimum limits requirements for Entry level and Intermediate level compliance and the Mimer SQL limit.

SQL_FEATURES

The SQL_FEATURES system view describes Mimer SQL compliance with each FIPS feature.

Column name
Data type
Description
FEATURE_ID
SMALLINT
The FIPS identifier for the feature.
FEATURE_NAME
CHAR(50)
The name of the FIPS feature.
CLASSIFICATION
CHAR(12)
Shows the FIPS conformance level at which the feature first becomes required.
One of:
TRANSITIONAL
INTERMEDIATE
FULL
RDA
.
IS_SUPPORTED
CHAR(3)
Shows whether the FIPS feature is supported in Mimer SQL or not. One of:
YES
NO
.
IS_VERIFIED
CHAR(3)
Shows whether Mimer SQL compliance has been externally verified or not. One of:
YES
NO
.
FEATURE_COMMENTS
VARCHAR(500)
May contain descriptive information about Mimer SQL support for the FIPS feature.

SQL_SIZING

The SQL_SIZING system view describes the minimum limits requirements for FIPS Entry and Intermediate level support and shows the Mimer SQL limits.

Column name
Data type
Description
SIZING_ID
SMALLINT
The FIPS identifier for the sizing limit.
DESCRIPTION
CHAR(50)
The description of the database construct sizing limit.
ENTRY_VALUE
INTEGER
The default Entry level sizing limit.
INTERMEDIATE_VALUE
INTEGER
The default Intermediate level sizing limit.
VALUE_SUPPORTED
INTEGER
The sizing limit supported by Mimer SQL.
SIZING_COMMENT
VARCHAR(500)
May contain comments on the sizing limit.

Standard Compliance

The table below summarizes standards compliance concerning the views in FIPS_DOCUMENTATION.

Standard
Compliance
Comments
X/Open-95
SQL-92
YES
Fully compliant.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX