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.