Does file exist on mainframe

a2love · Post by **a2love** » Mon Apr 16, 2007 2:38 pm

Hi all,

I am trying to finish up a job sequence that sends a success/failure notification if a file is/is not created on the mainframe. Does anyone know how to accomplish this? I assume it would be something like a script checking if file exists after logging into a server via FTP...

I am unsure of what direction to go with this, any suggestions?

ray.wurlod · Post by **ray.wurlod** » Mon Apr 16, 2007 3:47 pm

Probably a script, executed via an Execute Command activity, that establishes an FTP connection then tests for the existence of the file. Does FTP into the mainframe support the ls subcommand for ftp?

tiozzo · Post by **tiozzo** » Tue Apr 17, 2007 8:31 am

Ya ls is supported. So I'm thinking... ls and put that list into a file, exit ftp, and run dos to real file line by line looking for my file name. If present do something else. This sound like a good plan?

tiozzo · Post by **tiozzo** » Tue Apr 17, 2007 1:37 pm

Actually, to get more to the point....

1) does anyone know how to write to result of 'dir' or 'ls' to a file from Dos FTP.

or alternatively,

2) how to check if a file exists on mainframe from datastage

Any help or info on where to find some help would be greatly appreciated.

Cheers,
Adam

ray.wurlod · Post by **ray.wurlod** » Tue Apr 17, 2007 3:18 pm

Etiquette Note
Thread hijacking is frowned upon. Please start a new thread for your first question, Adam.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 17, 2007 3:20 pm

tiozzo wrote:Ya ls is supported. So I'm thinking... ls and put that list into a file, exit ftp, and run dos to real file line by line looking for my file name. If present do something else. This sound like a good plan?

Yes, but there's a better plan. You can use UNIX utilities as well. For example you can use grep to determine whether your particular file name exists in the ls output. This can be via an Execute Command activity in the job sequence.