Best Delimiter to use

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
highpoint
Premium Member
Premium Member
Posts: 123
Joined: Sat Jun 19, 2010 12:01 am
Location: Chicago

Best Delimiter to use

Post by highpoint »

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.
swapnilverma
Participant
Posts: 135
Joined: Tue Aug 14, 2007 4:27 am
Location: Mumbai

Post by swapnilverma »

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
Thanks
Swapnil

"Whenever you find whole world against you just turn around and Lead the world"
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
highpoint
Premium Member
Premium Member
Posts: 123
Joined: Sat Jun 19, 2010 12:01 am
Location: Chicago

Post by highpoint »

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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply