skip to main content
Connection Option Descriptions : Extended Column MetaData
  

Try DataDirect Drivers Now

Extended Column MetaData

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