KeywordConflictSuffix (configuration option)
- Last Updated: October 23, 2017
- 1 minute read
- DataDirect Connectors
- JDBC
- Oracle Eloqua 6.0
- Documentation
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
Oracle Eloqua 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
No default value
Data Type
String