skip to main content
Connection Option Descriptions for Apache Spark SQL : Remove Column Qualifiers
  

Try DataDirect Drivers Now

Remove Column Qualifiers

Attribute

RemoveColumnQualifiers (RCQ)

Purpose

Specifies whether the driver removes 3-part column qualifiers and replaces them with alias.column qualifiers. Microsoft Access executes a Select statement using this syntax when an index is specified on a linked table.

Valid Values

0 | 1

Behavior

If set to 1 (Enabled) the driver removes 3-part column qualifiers and replaces them with alias.column qualifiers. Column qualifiers are Microsoft Access compatible in this setting.
If set to 0 (Disabled), the driver does not modify the request.

Default

0 (Disabled)

GUI Tab

Advanced tab