DSXchange

My Computer / Properties... you'll find an Environment Variables setting there, under the Advanced tab I do believe. Update it there.

(confirmed)

No "looping" required nor does the size of the list matter. The "trick" to preventing substring matches has been posted here many times: include the delimiter in the search. So, search for ",1," rather than "1". Which also means you'll need to wrap your parame...

There's always the Index() function.

Yes. And the "how" of that is documented.

Right, reject links always post a warning when the number of rows that go down it is non-zero. If your job aborted because of that, you must be running it with a warning limit of 1.

pandeesh wrote:If i want to consider space also as a special character, i can include another condition with this:

Why? Did you not notice the space that is included in the first list of characters I posted? I even put it between the letters and numbers to make it more obvious for you.

Sounds like you need a new requirement.

Time to involve support, it would seem.

What flavor of Windows, a supported one? The only other post here that mentions your error only had the problem in Vista.

Why not simply test it yourself rather than ask me? A simple routine would allow multiple values to be tested quite easily and then you can decide if it solves your problem or not.

You can use the Convert() function:
If the result of that is not an empty string, it has at least one of your "special" characters in it.

What are you considering a "special" character here?

I changed your post's subject to something more meaningful than the original of "job logic". Please try to make them more appropriate in the future.

Just so you know, posting in all caps is considered SHOUTING. Please don't shout.

Unless there's been a major addition to the 8.5 version, DataStage has always relied upon underlying schedulers - Windows 'at' or UNIX cron/at. The Director client is basically a GUI interface to them.

Which part is unclear? Always best to ask specific questions. First ensure you can read multiple files, have you tried using the File Pattern yet? Also there is an option in the stage to add the filename as a field, enable that. That way you can check the value in a transformer to decide how to popu...