Sybase ASE Write Delimiter Issues
Posted: Sun May 30, 2010 7:56 pm
Hi
I would like to use Sybase Enterprise Parallel Job Stage with Write Method ASE Write to load some data into empty tables with no indexes. I am currently using ASE Upsert instead of ASE Write but it runs at half the speed.
Now I did get ASE Write working until we had some valid data containing | (pipe) and that was when it fell over with "Unexpected EOF encountered in BCP data-file." This issue being that the pipe was being treated as the delimiter.
Unfortunately with the version of Datastage (8.1) that we have there is no option to change the delimiter from pipe. Also we cannot change the data at all.
Any ideas? I've tried double-quoting the data but to no avail.
Thanks
Katy
I would like to use Sybase Enterprise Parallel Job Stage with Write Method ASE Write to load some data into empty tables with no indexes. I am currently using ASE Upsert instead of ASE Write but it runs at half the speed.
Now I did get ASE Write working until we had some valid data containing | (pipe) and that was when it fell over with "Unexpected EOF encountered in BCP data-file." This issue being that the pipe was being treated as the delimiter.
Unfortunately with the version of Datastage (8.1) that we have there is no option to change the delimiter from pipe. Also we cannot change the data at all.
Any ideas? I've tried double-quoting the data but to no avail.
Thanks
Katy