SQL_FEATURES

www.mimer.com/developer

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.

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.

Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se