'Wait For File Activity’ stage limitation

[ray.wurlod]

State your requirement in English (not DataStage). Is it, for example, one of a specific set of names that you have to wait for? Do you have to wait for any of them, or just one of them? If the latter, what happens then? You may be able to use a Routine.

[ray.wurlod]

You will need to use a Routine activity. It is important that the file is moved before or after processing, so that a subsequent scan does not find the file again. Imagine that you have three arguments to the routine; the directory where the files land, the directory to which they are to be moved for processing, and the wildcard pattern. Since you have 7.5x2 you have MKS toolkit and can therefore use UNIX commands such as ls -1 (as a possible alternative to the DOS command DIR /B) to get a list of file names matching your wildcard criterion. Use the output from this command as your list of file names (use REMOVE statement to extract one at a time), and either use UtilityRunJob or hand-coded job control code to run the job for each individual file name, moving the file to the new directory and passing the file name (and directory) as job parameter value.