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?
Pound sign (#) in Column name
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 15
- Joined: Tue Sep 09, 2003 10:41 pm
Re: Pound sign (#) in Column name
Hi,
# and $ are special characters.Check out the help manual section on handling special characters
Regards
Wah
# and $ are special characters.Check out the help manual section on handling special characters
Regards
Wah
-
- Premium Member
- Posts: 15
- Joined: Tue Sep 09, 2003 10:41 pm
Re: Pound sign (#) in Column name
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__' ??