DSXchange

I have a case where I do not know at runtime if an input file will exist. Is there a way to dynamically test from datastage if a file exists and continue on if it does not exist? I am running a sequence, and if the file does not exist, I do not want the job accessing it to abort, which would cause the sequence to abort. Any thoughts?

You could use the Execute Command stage to do (off the top of my head) a "test -f filename" on the file and then conditionally run the job based on the result. Or perhaps "-s" if you need to check if it exists and is not empty as well.

A Routine activity that did the same thing - either with a command or via BASIC statements such as OpenSeq - might be more flexible in terms of logging informative/alert messages. Of course you could also direct a trigger from the Execute Command activity to a logging routine activity.

Thanks for the help - you sent me the answer I was looking for and it works PERFECT!