DSXchange

I am trying to pass file name in wait for file activity stage.
File name changes for every run.

I was trying to give *.txt. but it seams stage does not accept wildcard.

Can any one please help me.

Thanks

I think you can use Output of Uservariable activity or Execute command activity output in Wait for file activity.

Welcome aboard.

As you've found, the WFF stage does not support wildcards so you'll need some other mechanism. How are your shell scripting skills? You could script something equivalent and then use an Execute Command stage to run it. Some other approaches inside DataStage are noted here and here.

My first stage is to FTP the files to folder, second is checking whether the files came over to the folder, so using wait for file activity to watch for files if they appear my next process starts if not process ends and sends notification

My OS is windows

Because of the underlying software DataStage uses, you can still use 'UNIX' scripts on a Windows DataStage server. That or replace all occurrences of "shell script" in my response with "batch file".

lkomala wrote:My OS is windows

You can use MKS tool kit also.Use following link or google for more information

en.wikipedia.org/wiki/MKS_Toolkit

As noted.