FTP file is empty

databind · Post by **databind** » Tue Oct 07, 2008 5:11 am

Hi,

I have .txt file on FTP server to be uploaded to Oracle. I would like to get messages if this file is empty. How can I do this through DS?

sachin1 · Post by **sachin1** » Tue Oct 07, 2008 5:17 am

Please let us know when you want to track for empty file before ftp or after ftp operation.

databind · Post by **databind** » Tue Oct 07, 2008 5:26 am

it should be before FTP operation

sachin1 · Post by **sachin1** » Tue Oct 07, 2008 5:36 am

to get message for empty file before ftp operation, you can create custom routine to check for file size and log the message, abort operation or continue operation.

sachin1 · Post by **sachin1** » Tue Oct 07, 2008 5:37 am

[quote="sachin1"]to get message for empty file before ftp operation, you can create custom routine to check for file size and log the message, abort operation or continue operation, routine to be used in before job subroutine

databind · Post by **databind** » Tue Oct 07, 2008 5:40 am

Does anyone have example of routine to get file size???
please help...

chulett · Post by **chulett** » Tue Oct 07, 2008 7:02 am

What O/S? Where - local to the DataStage server? Remote? Details of your requirements would be nice.

databind · Post by **databind** » Wed Oct 08, 2008 12:50 pm

Craig,
My DataStage server's OS is W2K3.
Files to load will be on FTP server(Linux or Unix).

chulett · Post by **chulett** » Wed Oct 08, 2008 12:53 pm

Ok, that's one part of the puzzle. Now just need to get a better idea what your requirements are, so why don't you lay that out for us?

ketfos · Post by **ketfos** » Wed Oct 08, 2008 2:41 pm

Hi,

You could use Before Job SubRoutine properties in Job Control window.
Select Before Job Routine ExecSh
Input value du -sk <filename>

This will give you file size.

Depending upon it you can take further action.

Ketfos

DSXchange

FTP file is empty

FTP file is empty

Re: FTP file is empty