Writing to a CSV file

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
muralisankarr
Premium Member
Premium Member
Posts: 83
Joined: Tue Oct 28, 2008 1:55 am
Location: Chennai

Writing to a CSV file

Post by muralisankarr »

Hi,

We have target file stage which writes to a CSV. We are getting box ch '[]' at the end of the file. How can we remove this? Please help

Thanks
rMS
The minute you start talking about what you're going to do if you lose, you have lost
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Change the stage properties from UNIX style to DOS style. The character at the end of the file is most likely a UNIX end-of-file character (Ctrl-D). You can check this with any hex editor; its value is 0x04.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”