Hi,
My requirement is to display the column name as "DENM_$5_A" in the output .csv file in Datastage. When i give the column name as "DENM_$5_A" in the ouput file metadata i am getting the compilation error.
Can anyone help on this.
Thanks in Advance.
Display "$" in output file column name
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
Re: Display "$" in output file column name
This is probably because you cannot give $ as a column name.
You can give teh column name as "AAAAAAAAA"
then in the after job subroutine you can replace it with DENM_$5_A
using Sed command
sed -e "s/AAAAAAAAA/DENM_$5_A/ig" $file > /tmp/tempfile.tmp; mv /tmp/tempfile.tmp $file
This should be a workaround
You can give teh column name as "AAAAAAAAA"
then in the after job subroutine you can replace it with DENM_$5_A
using Sed command
sed -e "s/AAAAAAAAA/DENM_$5_A/ig" $file > /tmp/tempfile.tmp; mv /tmp/tempfile.tmp $file
This should be a workaround
Re: Display "$" in output file column name
Hi,
Thanks a lot. I have implemented the logic given by you. Now it is working fine.
Thanks a lot. I have implemented the logic given by you. Now it is working fine.