DSXchange

Or use the date command surrounded by backquotes as part of the file name.

Or set it for just that project by creating a user-defined Environment Variable using the Administrator client.

Download ETLstats from Kim Duke's website and use that. No need to re-invent the wheel.

How have you set LIB and INCLUDE ?
How have you set the four project environment variables in the Compiler group?
Are you on a 32-bit or a 64-bit Windows operating system?

Correct. Though the SQL is logged in the job log.

Are these (this one and the "infinity rings" one) theoretical, or are they solving some real-world problem (and, if so, what problem)?

Create a job with an input link to the Surrogate Key stage.

There's no way to do it from UNIX.

Split the stream, perform the individual calculations, bring the streams back together (Link Collector) and perform the arithmetic.

OK, so what determines which ring a row belongs in?

Does this still occur if the Transformer stage is excluded?

There's no Remove Duplicates stage in Server jobs, but the Aggregator stage can be set up to yield First or Last record in group.

Transformer stage with two outputs, constrained on the value of the first column (R1 or R2).

Then use Round Robin partitioning.

Most database engines won't use an index if to do so would cost more than using a table scan, for example if most of the rows in the table are affected.

Not only U but anyone with a mainframe job licence can create COBOL source and JCL for compiling and running the same using the DataStage Designer client.

U is one of our posters. The second person personal pronoun in English is spelled "you".