Hi,
I want to get trasnferred multiple zip files from remote location.
So I am calling a shell script which is having certain unix commands to execute the same. how can it be done in Datastage7.5?
Or is there any other efiecient way to do it?
Call a shell script in datastage job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 23
- Joined: Fri Nov 04, 2005 8:34 am
Re: Call a shell script in datastage job
Please use FTP satge, if you mean transfer as 'Ftp'ingthis_is_venki wrote:Hi,
I want to get trasnferred multiple zip files from remote location.
So I am calling a shell script which is having certain unix commands to execute the same. how can it be done in Datastage7.5?
Or is there any other efiecient way to do it?
-
- Participant
- Posts: 23
- Joined: Fri Nov 04, 2005 8:34 am
I tried to use FTP plug-in stage but later i came to know it trasnfers data of the file rather than transferring the file.
Please send me detail property setting for FTP plug-in stage if it is possible to transfer the file (but i couldn't through it).
--------------------------------------------------------------------------------
prabhu wrote:
Please use FTP satge, if you mean transfer as 'Ftp'ing
Please send me detail property setting for FTP plug-in stage if it is possible to transfer the file (but i couldn't through it).
--------------------------------------------------------------------------------
prabhu wrote:
Please use FTP satge, if you mean transfer as 'Ftp'ing
-
- Participant
- Posts: 23
- Joined: Fri Nov 04, 2005 8:34 am
what I mean to say is when I tried with FTP plug-in Stage, I needed to mention all the column name for the output link but i have the files in zip format. So I think file cann't be read until it gets unzipped.
Morever according to my perception FTP plug-in stage doesn't copy the file rather transfers the data like we load data from one table to another table. So in case of FTP, files are two different tables. But my basic need is copying the file not retrieving data & loading it into another file.
Becase it is in zip format & cann't be read until it gets unzipped.
May be I get wrong perception about the stage if it possible please send me detail poperty setting of the stage.
Thanks,
Venky
Morever according to my perception FTP plug-in stage doesn't copy the file rather transfers the data like we load data from one table to another table. So in case of FTP, files are two different tables. But my basic need is copying the file not retrieving data & loading it into another file.
Becase it is in zip format & cann't be read until it gets unzipped.
May be I get wrong perception about the stage if it possible please send me detail poperty setting of the stage.
Thanks,
Venky
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: