Columnname containing # in transformer derivation

[psluser]

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,

[chulett]

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.