DSXchange

Funnel stage is definitely not it, for the reasons you noted. What do you want the output to look like? Is there a column in all three files that a Join stage could use? Or a cascaded pair of Join stages, if there are two common pairs of keys?

Yes, provided that you have either version 7.5x2 (which is not the same as 7.5.2) or version 8.0 of DataStage installed on that Windows 2003 server.

Looks like there might be such a limit. It's not documented in the manuals. Ask your support provider, who can ask IBM engineering.

I wonder if it's treating the characters as hex digits.

Would you mind sharing what the workaround is, since you've marked it thus? From that we may be able to find a solution.

There's a Delimited Flat File stage. You can specify the delimiter as a three-digit decimal ASCII code or as a two digit hexadecimal ASCII code preceded by "&H". See page 6-5 of the Mainframe Job Developer's Guide for full information.

When you get version 8.0 there is a particularly wonderful resource estimator tool. Never use NFS-mounted disks for scratchdisk, and avoid using NFS-mounted disks for resource "disk" (where Data Set and File Set data files are positioned). Avoid those disks being used for extraction and load for oth...

Please refrain from using "u" for the second person pronoun - we have a Burmese user called U enrolled who - it appears - finds it offensive.
Given that the OP has also mentioned hashed files, it is opportune to ask whether this is a parallel job at all.

Provided that you have used RESIZE to convert &PH& to type 19 you can use the find command with impunity.

If you're using a BASIC routine you can use the STATUS statement to determine the date/time modified and render your deletion decision on that basis. But find will be faster.

It's totally impossible if there's a mix of DD/MM/YY and MM/DD/YY because of the ambiguity inherent therein. Demand a consistent format or a format flag.

The easiest way to determine the exit status of Aborted/Restartable is to use dsjob to get that status when you have a job sequence in this state. But, as 2B said, you don't need to reset these - indeed, if you do, you will lose any checkpoints that allow successful activities to be skipped upon res...

Why are you reinventing the wheel? Get ETLStats from Kim Duke's web site - the price is right!

If you want to re-map the exit status from the dsjob exit status, that's fine - you can do that. If dsjob exit status is 1, exit 0; if dsjob exit status is 2, probably exit 0 also. Otherwise exit 1.

Because the OP is on Windows, the Data Direct driver issues are more readily worked around by using different drivers. But everything I posted earlier remains apposite.

Use the Fix() function to specify the largest number of decimal places, then add 0 to that result to remove trailing non-significant zeroes.

To get out of DS.TOOLS just press Enter enough times.
To get out of dssh, enter the command QUIT.
To log out from the operating system the command is exit.