Sequential File to be FTP'd with column headings

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
pavans
Participant
Posts: 116
Joined: Sun Sep 10, 2006 7:33 am
Location: bangalore, india

Sequential File to be FTP'd with column headings

Post by pavans »

Hi

We have a parallel job where target is sequnetial file.
We need to FTP this sequential file along with the column names to a remote location.

Can u please help me.

Thanks in advance.
Thanks,
Pavan
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

If you create the sequential file with First Line is Column Names set to True then the column names will be in the file.

FTP is simply a matter of invoking the appropriate command (I prefer to wrap it in a shell script) and invoking that from DataStage, perhaps via an after-job subroutine, perhaps via an Execute Command activity.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Aruna Gutti
Premium Member
Premium Member
Posts: 145
Joined: Fri Sep 21, 2007 9:35 am
Location: Boston

Post by Aruna Gutti »

You can actually use FTP-Plugin stage as a target and create your output file with headings.

Please specify 'Yes' to first line column names option in Input Properties tab.

Regards,

Aruna.
Aruna Gutti
Premium Member
Premium Member
Posts: 145
Joined: Fri Sep 21, 2007 9:35 am
Location: Boston

Post by Aruna Gutti »

You can actually use FTP-Plugin stage as a target and create your output file with headings.

Please specify 'Yes' to first line column names option in Input Properties tab.

Regards,

Aruna.
Post Reply