DSXchange

Hi,

We are designing a job. Input is a file.
Its our choice to choose which delimiter we like for the input file.

We thought of using "|" as delimiter.
But found that data can also have "|' in it. We dont know how the data will be.

Is there any delimiter specific to datastage.
If not please suggest the best safest delimiter to use in this job.

Appreciate reply.

thr is no hard rule to use any delimiter.

and as far as I knw no such thing as "DataStage Delimiter "


you can use any non printable ASCII code as delimiter.
This will insure that it will not come as "DATA "

hope this helps

The best delimiter is any character that does not occur in the data. As noted, this might be a non-printing character, such as tab or Ctrl-Y.

ray.wurlod wrote:The best delimiter is any character that does not occur in the data. As noted, this might be a non-printing character, such as tab or Ctrl-Y.

How to check for Ctrl-Y in datastage transformer logic.

Appreciate reply.

Char(25)

All of the Ctrl-letter characters map to their ordinal position in the English alphabet. So, for example, Crtl-L is Char(12), Ctrl-T is Char(20).