DSXchange

I have a target AS400 file/table with a pound sign in the column name. Example, P1STR# and P1REG#.

When typing the column name in the target DB stages, I get an error that DS cannot accept the # sign in the column name.

How can I write data into a column with the pound # sign, when DS does not allow the # in the metadata?

Hi,

# and $ are special characters.Check out the help manual section on handling special characters

Regards
Wah

wahi80 wrote:Hi,

# and $ are special characters.Check out the help manual section on handling special characters

Regards
Wah

Thanks... I found the Help page about the # sign in the column name. I have enabled the environment variable DS_ENABLE_RESERVED_CHAR_CONVERT to True. It still gives me the error when I type the column name 'P1REG#'. The help page talks about importing the meta data (I cannot do that now due to access issues). But I want to be able to type out the column name for now.

The page mentions '__035__' as the character to replace '#'. Will that work, typing the column name as 'P1REG__035__' ??

You could have very well tried typing in Datastage by the time you typing it here.

Not sure if you can do this in Parallel, but we use this workaround in server ODBC DB2 target stages.

You have to drop the # sign from the DataStage column name and change to "User Defined SQL". You then have to key in the INSERT or UPDATE statement using the # sign in your column name(s).