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.
Best Delimiter to use
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 135
- Joined: Tue Aug 14, 2007 4:27 am
- Location: Mumbai
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
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"
Swapnil
"Whenever you find whole world against you just turn around and Lead the world"
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: