Talking a lot about Informatica keeping Database at bay, doesn’t really make mush sense. At least we can’t avoid the database issues for long. This post deals the support for reserve words as column names of database tables in Informatica.
It’s quite common to use columns names like “Comment” in the tables (At least that was how I learnt about Reserve words). But once you try to populate such table, you may get a database driver error.
For example: Suppose you are using Oracle as your database, and the source or target table has a reserve word say “Year” as a column name then you may get following error:
“WRT_8229 Database errors occurred
SQL0199N The use of the reserved word "YEAR" following "" is not valid”
Solution:
Informatica Version 8.1.1 comes with support for Reserve word issues. All you need here is a file named reswords.txt that is created in the Integration Service installation directory or the installation directory of Informatica. In this file you may have entries in the following format:
[ORACLE]
Comment
Year
[DB2]
Year
Select
This file is then located by the Integration Service which places quotes around reserved words every time an SQL statement is used any database.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment