# symbol is causing problem when concatenating

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
datastage_slk
Participant
Posts: 4
Joined: Mon Jan 26, 2009 5:50 pm

# symbol is causing problem when concatenating

Post by datastage_slk »

When I concatenate all the fields in a transformer to send it to funnel. I am using one of the field from job parameters. That field has # symbol in it.

It throws an error if that field has # symbol.

any solution for this is really appreciated.
Beginner
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Moderator: please move to parallel forum

Server jobs do not have a funnel stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Use a view or something to create a field without # in the name.
Mamu Kim
Post Reply