Informatica 8.6.1: How To Avoid Erros Due to Reserved Words

In order to avoid SQL error at run-time due to reserved words at columns names you can do the following:


    1.  Create a reserved words file, reswords.txt, in the <PowerCenter_Home>\server\bin directory.

    2.  Specify the reserved words in the reswords.txt.

           Following is a sample resword.txt file:

           [SQL Server]
           RETURN
           TRANSACTION

            In the reswords.txt file, the following connection headers can be provided: 

            

                    [Teradata]

                    [Oracle]

                    [DB2]

                    [Sybase]

                    [Informix]

                    [SQL Server]

                    [ODBC]

                    [NEOVIEW]

                    [Netezza]

    3.  In Informatica Administrator, select the Data Integration Service and ddit the custom properties. 


    4. Add the following custom property:

    5.  Restart Integration Service. 


    6.  (OPTIONAL) Set the following value under Custom Properties in the Session Config Object 

          Properties tab:

                    ?Attribute: ReservedWordsFile

                    ?Value: C:\informatica\Powercenter8.6.1\server\bin\resword.txt