DSXchange

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,

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.