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. |
FIPS_DOCUMENTATION.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. |
FIPS_DOCUMENTATION.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
|
|
|
Mimer SQL extension |
These views are based on the FIPS PUB 127-2 standard. |
