The table below summarizes the system views that are part of the schema FIPS_DOCUMENTATION (view names appear in their unqualified form):
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.
The SQL_FEATURES system view describes Mimer SQL compliance with each FIPS feature.
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.
IS_SUPPORTED CHAR(3) Shows whether the FIPS feature is supported in Mimer SQL or not. One of:
IS_VERIFIED CHAR(3) Shows whether Mimer SQL compliance has been externally verified or not. One of:
FEATURE_COMMENTS VARCHAR(500) May contain descriptive information about Mimer SQL support for the FIPS feature.
The SQL_SIZING system view describes the minimum limits requirements for FIPS Entry and Intermediate level support and shows the Mimer SQL limits.
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.
The table below summarizes standards compliance concerning the views in FIPS_DOCUMENTATION.
Mimer SQL extension These views are based on the FIPS PUB 127-2 standard.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40