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