Change delimiter used for BCP IN by Sybase Enterprise Stage

[asingh]

When attempting to load a Sybase table using the Enetrprise Stage we find that it uses a pipe delimiter by default when performing the BCP IN. Our data contains pipes and this causes the job to fail so we'd like to modify the delimiter used. Is this possible? Also where are the Control and data files used by the BCP stored and are they persistent or temporary?

[ray.wurlod]

I can't see any property in the stage that allows this. However, if non-numeric data types are quoted in the data file, the fact that you have delimiter characters in the data should not matter. Are you using IQ Write or ASE Write?

If you use the Sybase IQ Load stage you have full control over the location of control and data files as well as of the delimiter character.

[asingh]

Had a chat to IBM support regarding this and apparently the release 8.1 GA does not have the delimiter option available although it was released as a patch for 7.5.

To resolve this we need to install Fix Pack 1 to get the desired functionality.