skip to main content
Connection Option Descriptions : Config Options : KeywordConflictSuffix (Config Option)
  

Try DataDirect Drivers Now

KeywordConflictSuffix (Config Option)

Purpose

Specifies a string of up to five alphanumeric characters that the driver appends to any object or field name that conflicts with a SQL engine keyword.

Valid Values

string
where:
string
is a string of up to five alphanumeric characters.
The value for this option is specified as a key=value pair in the Config Options field. See "Config Options" for details.

Example

A field called CASE exists in the native Salesforce data. To avoid a naming conflict with the SQL engine keyword CASE, you could set KeywordConflictSuffix=TAB. In this scenario, the driver maps the Case object to the CASETAB column.

Notes

*Do not use a string that matches the suffix of a custom table, for example, CASEOFICE. If you specify KeywordConflictSuffix=OFICE, a name collision occurs with the Standard object CASE and the custom table CASEOFICE, or a table with a column called CASEOFICE. In this situation, the standard object CASE is returned. The custom object is ignored.

Default

Empty string

GUI Tab

The value for config options are specified in the Config Options field on the Advanced tab.

See also

Config Options