Attribute

ExtendedColumnMetaData (ECMD)

Purpose

Determines how the driver returns column metadata when using SQLDescribeCol and SQLColAttribute.

Valid Values

0 | 1

Behavior

If set to 1 (Enabled), SQLDescribeCol returns the actual values for Data Type, Column Size, Decimal Digits, and Nullable. SQLColAttribute returns the actual values for:

• SQL_DESC_CATALOG_NAME: catalog_name
• SQL_DESC_TABLE_NAME: table_name
• SQL_DESC_BASE_COLUMN_NAME: base_column_name
• SQL_DESC_LOCAL_TYPE_NAME: local_type_name
• SQL_DESC_NULLABLE: nullable
• SQL_DESC_AUTO_UNIQUE_VALUE: auto_unique_value

If set to 0 (Disabled), SQLDescribeCol returns the Data Type, Column Size, and Decimal Digits for the column. The value SQL_NULLABLE_UNKNOWN is returned for Nullable. SQLColAttribute returns the following attribute values:

• SQL_DESC_CATALOG_NAME: empty string
• SQL_DESC_TABLE_NAME: empty string
• SQL_DESC_BASE_COLUMN_NAME: empty string
• SQL_DESC_LOCAL_TYPE_NAME: empty string
• SQL_DESC_NULLABLE: SQL_NULLABLE_UNKNOWN
• SQL_DESC_AUTO_UNIQUE_VALUE: SQL_FALSE

Default

0 (Disabled)

GUI Tab

Advanced tab