DSXchange

There is only one node, so the question is moot. This is the server forum.

Still waiting for the output from clicking More to be posted, or for the thread to be marked as resolved.

The scope of a stage variable is within a stage. The scope of a job variable is within a job (though there's really no such thing as a job variable). The scope of a COMMON variable is within a single process. You could use the job's user status area to store a value, and retrieve it subsequently usi...

If "remove automatically" is set to Yes, the TMU file is removed once the load has occurred.

What about partitioned on the join key(s)?

Welcome aboard. :D

Before Join stage will work properly both its inputs much be identically partitioned and sorted on the join key(s). Is this the case in your job?

I think it's much more likely that /tmp fills during a job run. Can you, or the UNIX Administrator, delete anything unneeded from the /tmp directory and/or allocate more space to it?

Sorry about the delay. You can find it here - right-click and Save Target As... to get the DSX file.
Please heed copyright requirements (can be re-used if copyright notice is preserved).

Each job requires one conductor process (on the "conductor node"), one section leader process per node and as many as one player process per stage per node. These are allocated automatically by the parallel engine. Allocation as described may change due to operator combination and restriction of par...

Not all operating systems deliver microseconds.

It's a directory. Put them there using cp or mv (on UNIX) or COPY (on Windows). Or any other file moving tools that you may have.

Cost varies (for example, the Advanced class has optional modules). Bulk discounts are available. Please email me with your requirements.

System(12) gives milliseconds. You can also set $OPTIONS TIME.MILLISECONDS as a compiler directive.

Installation may not care, but runtime may, hence my caution. No point installing if it's not going to work.

Put them in the Data directory of the QualityStage project.

The error is coming from Oracle. Use the oerr command to get recommendations for remedial action. At a quick glance your timestamp formats do appear to match your date pictures in the TO_DATE function.