Hi,
I have a data stage job which reads from a SQL server DB and writes to oracle DB. Datastage flow for this contains
OLEDB stage -> Transformer stage -> Oracle stage
One of the input column name is 'File#'.
I am able to load the table definition in columns tab.
But when i use this column in derivation of transformer stage 'DSLink.File#' it gives compilation error.
I have tried to set the 'DS_ENABLE_RESERVED_CHAR_CONVERT' as true at project level, but the issue is not resolved.
Please let me know if anyone has the solution.
Thanks in advance,
Columnname containing # in transformer derivation
Moderators: chulett, rschirm, roy
You need to read the documentation for the stage. Off the top of my head, you set that environment variable and you then use a different character (or pair of characters?) to represent the # in the job and it translates it/them back under the covers.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers