replace quote character " " with ~#
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Convert() replaces characters on a one-for-one basis. You will need the pxEreplace() function, which does not come with DataStage but source code for which you can find on DSXchange.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 96
- Joined: Fri Aug 20, 2010 8:51 am
It looks like you are compiling this as a server routine and it is interpreting this as a BASIC Program rather than a c++ program.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 96
- Joined: Fri Aug 20, 2010 8:51 am
Yes, you need to define the custom routine in DataStage and also compile and bind your program outside of DataStage. I just took a quick look at the thread with the pxreplace code and it contains some instructions on the compile and links to threads, I suggest you start there.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>