DB2 Universal Database for iSeries SQL Reference

SQL_FEATURES

The SQL_FEATURES view contains one row for each feature supported by the database manager. The following table describes the columns in the view:

Table 157. SQL_FEATURES view

Column Name Data Type Description
FEATURE_ID VARCHAR(7) ANS and ISO feature ID
FEATURE_NAME VARCHAR(128) The name of the ANS and ISO feature.
SUB_FEATURE_ID VARCHAR(7) ANS and ISO subfeature ID
SUB_FEATURE_NAME VARCHAR(256) The name of the ANS and ISO subfeature.
IS_SUPPORTED VARCHAR(3) Indicates whether the feature is supported:

YES
This feature is supported.

NO
This feature is not supported.

IS_VERIFIED_BY VARCHAR(128)
Nullable
Reserved. Contains the null value.
COMMENTS VARCHAR(2000)
Nullable
Reserved. Contains the null value.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]