Page 1 of 1

Sequential File to be FTP'd with column headings

Posted: Wed Jan 23, 2008 7:56 am
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.

Posted: Wed Jan 23, 2008 8:36 am
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.

Posted: Thu Feb 07, 2008 3:29 pm
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.

Posted: Thu Feb 07, 2008 3:30 pm
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.