Originally posted by: phil2030
Okay, if that is what you are doing, the only thing I can think of is to substitute the character for something else in your query (maybe "&pipe;") and then replace it back in the map when needed. (You would have to do this for each column that might be affected.) The pipe is hard coded in the db* functions and there isn't a way of getting a release character in there (not that I think it would do you a lot of good in this case as you would still have the pipe just prefixed by something else, the word function would still return the same data).
Alternatively, if you don't want to do the replacement then (if you can) you might want to refine you SQL query and return just the data that you are looking for when using the word function. This obviously might mean more db calls, but...
Another alternative is to run a map to get the result set back and as Yusuf pointed out, replace the delimiter in the output tree it uses...
#IBM-Websphere-Transformation-Extender#IBMSterlingTransformationExtender#DataExchange