DSXchange

The OP has begun a new thread here on this topic.

Use a job sequence with a Start Loop and End Loop activity. Set up your loop as a "list of things" loop generated by listing the file of file names. Invoke the job within the loop.

And are the timestamps close to the "log purged" timestamp? What is the status of the job sequence in Status view?

Parallel jobs can be run on Windows provided that the DataStage version is 7.5x2.

Parallel jobs can be run on Red Hat AS3.0. The Server to Parallel Transition Lab offered through DCS is run on a Linux server. This is running version 7.5.1 of DataStage.

First case: get the mainframe folks to effect the join for you and process one file. Second case: get the five files joined before extraction, and use Join stage (?) for the remainder. The parallel job philosophy is to keep everything in memory as much as possible so, if you have the resources, do i...

HOW is it not working? The Trim() function should remove the leading zeroes (if syntactically correct - no quotes around the first argument). The fact that your target data type is Char will mean that the value will be right-padded with spaces. If you don't want that, don't use Char.

Don't use a Transformer stage - that's server job thinking. Use a date format string in whatever stage you are using to read the Excel data.

The SRT file is sorted by pattern. But that doesn't mean you can't re-sort it by unhandled pattern, or run it through a filter that eliminates those rows that have an empty (all spaces) unhandled pattern field.

Auto purge only happens AFTER successful completion. Look slightly earlier in the log for the "completed" message.

Not possible in the way that you envisage. You could use AT, however, if you have appropriate privileges. Recall that AT has a COMPUTERNAME switch that allows you to start commands on other computers. If there is a restart bat file on the server you can use that. Otherwise issue a stop command (uv -...

Thank you for sharing that. Your unasked question can not be answered without additional information. Describe your hardware. That the message resulted from a call to mmap() one would ordinarily conclude that you ran out of memory. What data volume are you processing? What are your buffer settings? ...

Got there today. On budget ($0) and ahead of schedule. Ta da!

... a task much less difficult if you have QualityStage.

Not "should have", "must have".

Inadvertently, perhaps, you've stumbled on the cause and correct solution. If someone puts any other file in a directory that is a dynamic hashed file (other than DATA.30, OVER.30 and .Type30) it ceases to be a dynamic hashed file and reverts to being a regular directory (known to DataStage BASIC as...