Call a shell script in datastage job

this_is_venki · Post by **this_is_venki** » Fri Aug 18, 2006 5:19 am

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?

balajisr · Post by **balajisr** » Fri Aug 18, 2006 5:25 am

One way would be to use before/after job subroutine using ExecSH option or use ExecCommand activity in the job sequence.

prabu · Post by **prabu** » Fri Aug 18, 2006 5:37 am

this_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?

Please use FTP satge, if you mean transfer as 'Ftp'ing

this_is_venki · Post by **this_is_venki** » Fri Aug 18, 2006 7:25 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

thumsup9 · Post by **thumsup9** » Fri Aug 18, 2006 9:06 am

What do you mean by transferring data and not file. You have to mention the destination filename in FTP stage and your source file gets in there.Are you trying to delete your source file once FTP is done?

this_is_venki · Post by **this_is_venki** » Mon Aug 21, 2006 12:31 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

ray.wurlod · Post by **ray.wurlod** » Mon Aug 21, 2006 1:24 am

You are correct to assert that the FTP stage is not equipped to unzip / uncompress compressed files.

DSXchange

Call a shell script in datastage job

Call a shell script in datastage job

Re: Call a shell script in datastage job