Developer Tool Guide

Back Next

Example: Database Uses Case-Sensitive Identifiers

In this example, the database uses case-sensitive identifiers. The database might use keywords or special characters in some identifiers, or it might not.

In the database connection, configure the identifier properties as follows:

Set the

SQL Identifier Character

property to the character that the database uses for delimited identifiers.

This example sets the property to "" (quotes).

Select the

Support Mixed-case Identifiers

property.

When the Data Integration Service generates SQL queries, the service places the selected character around all identifiers. For example, the Data Integration Service generates the following query:

SELECT * FROM "MyTable"    /* case-sensitive identifier enclosed within delimited character */
WHERE "MYCOLUMN" = 10    /* regular identifier enclosed within delimited character */

Rename Saved Search

Table of Contents

Developer Tool Guide

Developer Tool Guide

Example: Database Uses Case-Sensitive Identifiers

Example: Database Uses Case-Sensitive Identifiers