Extended ascii character as field delimiter

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Ed Purcell
Premium Member
Premium Member
Posts: 23
Joined: Fri Mar 28, 2003 5:41 pm
Location: USA

Extended ascii character as field delimiter

Post by Ed Purcell »

I have a sequential file with char(128) C-cedilla as the delimiter string. How do I enter that as the field delimiter in the sequential stage?
EPCCTX
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Yuk, yuk, a thousand times yuk! Microsoft have chosen to use Char(128) to represent the Euro character; DataStage server jobs use it as the internal representation of NULL. Seriously consider running the file through a tr command to change the \x80 character to something else - anything else!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply