accessing zip files

kum_d · Post by **kum_d** » Wed Aug 01, 2007 4:42 am

Hi

I need to FTP the previous month zip file on every month 2nd into datastage server from unix server.
But in unix server we have earlier monthly files say June2007.gz,May2007.gz,April2007.gz etc.... which are from more than 1 year.

Can any one help me out for how to catch the previous months file into datastage server.

This has to be autamated on everymonth 2nd.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 01, 2007 2:47 pm

Sort them by date/time modified then select the most recent.

Code: Select all

ls -rt1 | head -1

Execute Command activity to execute something like the above command; the return value will give you the file name which you can pass to the job as a job parameter value.

kum_d · Post by **kum_d** » Wed Aug 01, 2007 9:29 pm

Hi Ray,

Is it possible to use more then one command in telnet before command as i need to get the most recent file from unix server and rename it to kkk.txt in FTP stage.

Can you pls suggest me how can i do this in datastage

ray.wurlod · Post by **ray.wurlod** » Wed Aug 01, 2007 11:32 pm

You can capture the result of the ls command using backquotes, and use that as the first argument of the mv command that renames (or copies) the file prior to its being transferred.

kum_d · Post by **kum_d** » Thu Aug 02, 2007 2:42 am

Hi Ray,

Can we get multiple files(more than one file) from unix server to datastage server using GET command.

Cr.Cezon · Post by **Cr.Cezon** » Thu Aug 02, 2007 2:50 am

you must use then mget command
[
quote="kum_d"]Hi Ray,

Can we get multiple files(more than one file) from unix server to datastage server using GET command.[/quote]

kum_d · Post by **kum_d** » Thu Aug 02, 2007 2:50 am

can i have the syntax of the same

chulett · Post by **chulett** » Thu Aug 02, 2007 5:55 am

It's the same as 'get' just with an 'm' on the front and a wildcard in the filename. That's it. Try 'man ftp' for more information.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 02, 2007 6:04 am

OP is on Windows, but maybe has MKS Toolkit or similar.

On Windows open a cmd shell and invoke ftp. When the ftp> prompt appears type in a single ? or the word help to get a list of help topics.

chulett · Post by **chulett** » Thu Aug 02, 2007 6:17 am

Doh! Could have sworn I rolled back and checked the OS on the first post, obviously not. Perhaps it was your 'ls -rt1' and the mention of the remote UNIX server that threw me...

Still, that's still all there is to it - other than the need to invoke ftp with the -i option to turn off 'Interactive' mode. As far as I know, you still need to do that for a scripted mget so it doesn't stop and attempt to confirm each one.

kum_d · Post by **kum_d** » Thu Aug 02, 2007 9:13 pm

Hi

I have the folder path like this in unxi server: /home/users/ftptci
This path is having the files like May2007.gz,June2007.gz,Jul2007.gz as well other files say 58.gz ,xxxx.gz .
Out of these files which are different names along with monthly file names
as mentioned above.
I need to capture the latest monthly file into my datastage job using FTP stage.

Can you plesae help me out for this.

kum_d · Post by **kum_d** » Thu Aug 02, 2007 10:13 pm

any one help on this please

chulett · Post by **chulett** » Thu Aug 02, 2007 10:26 pm

I counsel... patience.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 02, 2007 10:48 pm

If you don't like the previously offered solution, please say so. It can also be done with a routine, using the STATUS statement to determine the date/time modified (for example).

If you're looking for someone to do the work for you, please contact them privately for a quotation.

kum_d · Post by **kum_d** » Thu Aug 02, 2007 11:14 pm

can you please give me any sample routine which works for this