skip to main content
Connection Property Descriptions : ConfigOptions : KeywordConflictSuffix (Configuration Option)
  

Try DataDirect Drivers Now

KeywordConflictSuffix (Configuration 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.

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

See also

ConfigOptions