Descriptor Field Conformance

The following table indicates the conformance level of each ODBC descriptor header field, where this is well-defined.

Function

Conformance level

SQL_DESC_ALLOC_TYPE	Core
SQL_DESC_ARRAY_SIZE	Core
SQL_DESC_ARRAY_STATUS_PTR	Core (for APD, IPR, and IRD); Level 1 (for ARD)
SQL_DESC_BIND_OFFSET_PTR	Core
SQL_DESC_BIND_TYPE	Core
SQL_DESC_COUNT	Core
SQL_DESC_ROWS_PROCESSED_PTR	Core

The following table indicates the conformance level of each ODBC descriptor record field, where this is well-defined.

Function

Conformance level

SQL_DESC_AUTO_UNIQUE_VALUE	Level 2
SQL_DESC_BASE_COLUMN_NAME	Core
SQL_DESC_BASE_TABLE_NAME	Level 1
SQL_DESC_CASE_SENSITIVE	Core
SQL_DESC_CATALOG_NAME	Level 2
SQL_DESC_CONCISE_TYPE	Core
SQL_DESC_DATA_PTR	Core
SQL_DESC_DATETIME_INTERVAL_ CODE	Core [1]
SQL_DESC_DATETIME_INTERVAL_ PRECISION	Core [1]
SQL_DESC_DISPLAY_SIZE	Core
SQL_DESC_FIXED_PREC_SCALE	Core
SQL_DESC_INDICATOR_PTR	Core
SQL_DESC_LABEL	Level 2
SQL_DESC_LENGTH	Core
SQL_DESC_LITERAL_PREFIX	Core
SQL_DESC_LITERAL_SUFFIX	Core
SQL_DESC_LOCAL_TYPE_NAME	Core
SQL_DESC_NAME	Core
SQL_DESC_NULLABLE	Core
SQL_DESC_OCTET_LENGTH	Core
SQL_DESC_OCTET_LENGTH_PTR	Core
SQL_DESC_PARAMETER_TYPE	Core/Level 2 [2]
SQL_DESC_PRECISION	Core
SQL_DESC_SCALE	Core
SQL_DESC_SCHEMA_NAME	Level 1
SQL_DESC_SEARCHABLE	Core
SQL_DESC_TABLE_NAME	Level 1
SQL_DESC_TYPE	Core
SQL_DESC_TYPE_NAME	Core
SQL_DESC_UNNAMED	Core
SQL_DESC_UNSIGNED	Core
SQL_DESC_UPDATABLE	Core

[1] Support for these record fields is required only if the driver supports the applicable data types. [2] For Core-level conformance, the driver must support SQL_PARAM_INPUT. For Level 2 interface conformance, the driver must also support SQL_PARAM_INPUT_OUTPUT and SQL_PARAM_OUTPUT.