Developer Tool Guide

Back Next

Creating a Reserved Words File

Create a reserved words file if any table name or column name in the customized data object contains a database reserved word.

You must have administrator privileges to configure the Data Integration Service to use the reserved words file.

Create a file called "reswords.txt."

Create a section for each database by entering the database name within square brackets, for example, [Oracle].

Add the reserved words to the file below the database name.

For example:

[Oracle]
OPTION
START
where
number
[SQL Server]
CURRENT
where
number

Entries are not case sensitive.

Save the reswords.txt file.

In Informatica Administrator, select the Data Integration Service.

Edit the custom properties.

Add the following custom property:

Name	Value
Reserved Words File	<path>\reswords.txt

Restart the Data Integration Service.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.