Developer Tool Guide

Back Next

Example: Database Uses Keywords or Special Characters in Identifiers

In this example, the database uses keywords or special characters in some identifiers. The database uses identifiers that are not case sensitive.

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).

Clear the

Support Mixed-case Identifiers

property.

When the Data Integration Service generates SQL queries, the service places the selected character around identifiers that use a reserved keyword or that use a special character. For example, the Data Integration Service generates the following query:

SELECT * FROM "MYTABLE$@"   /* identifier with special characters enclosed within delimited 
          character */
WHERE MYCOLUMN = 10   /* regular identifier not enclosed within delimited character */

Rename Saved Search

Table of Contents

Developer Tool Guide

Developer Tool Guide

Example: Database Uses Keywords or Special Characters in Identifiers

Example: Database Uses Keywords or Special Characters in Identifiers