skip to main content
Part 4: The Connect XE Drivers : The Greenplum Wire Protocol Driver : Connection Option Descriptions : Extended Column MetaData
  
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