Page 1 of 1

Extended ascii character as field delimiter

Posted: Mon Sep 17, 2007 7:18 pm
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?

Posted: Mon Sep 17, 2007 8:33 pm
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!