Edit

Descriptor Field Conformance

  • Article

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_ROWVER Level 1
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.