Reading a Sequential File with 'Non-Standard' Delimiters
Moderators: chulett, rschirm, roy
PX Jobs can use any delimiter; I think that the issue you are seeing is that you are putting the delimiter character in the wrong location in the sequential file definitions. I'm not at a client now so can't do an exact walkthrough, but if you start with a new sequential file stage (to make sure that other changes you might have made don't affect the outcome) and just change the field delimiter from a pipe to your u-umlaut and post the error message, if any.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Use "od" to see what the delimiter character in the source file really is after the transfer to UNIX, then specify that character. This is the probable cause. To test delimeters, just choose a letter or displayable character in your file and set that as delimiter, your error message should now move to another column.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Are you using NLS? It is just that I have used odd delimiters without issue in both Server and Parallel jobs, thus I think your error is not something inherent in DataStage but in your definitions or environment somewhere.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Could you try using a letter that is found in the file as a delimiter to see if your error shifts from the first column to the second (or subsequent) columns?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>