DSXchange

There is an ODBC stage for Progress, though it does not ship with DataStage; you will have to obtain it from your progress vendor (or via the web). I am not aware of any dedicated stage type for Progress - certainly none ships with the product, but someone may have created one. None of my clients th...

The dsjob command is fully documented in the Parallel Job Advanced Developer's Guide - you can read all about it there.

The -lprojects option lists all projects on a server, the -ljobs option lists all jobs in a given project.

The easiest way is to use Director itself. Disable display of folders, then use Print from the Project menu. There is a print to file option in the Print dialog.

You can't do this with an array size or transaction size (commit interval) above 250.

Use a reject link on the Oracle Enterprise stage. Run this through any stage type that allows a row limit to be set on a link, such as a Transformer stage.

Three unconstrained outputs from the Transformer stage will get A out one link, B out one link and C out one link. Trouble is, all rows will go out all links - that's what "no constraints" means. You could use one output link and a downstream Switch stage. But what's the aversion to using ...

It's not a case of "the" file, as I understand the problem. It's any number of files, named xxxx_CLM.dat, with xxxx coming from the data.

It can't be done. The File property is established when the stage opens.

There is a hard-coded solution for a small, finite and "known a priori" number of values.

No.

Not sure what you mean. Can you provide an example?

You're right but you can achieve the same result with much less processing using Copy stage to filter the required columns.

kduke wrote:The 59 field in the ROOT record of DS_JOBOBJECTS is the multiple instance flag there.

Edited my DML accordingly.

|| and && are called pipeline operators - they exist between two commands in a pipeline. command1 || command2 command2 will only execute if command1 fails (its exit status is non-zero) command1 && command2 command2 will only execute if command1 succeeds (its exit status is zero) comm...

Right click in the background of Monitor to enable "Show Instances".

Monitor DOES show intermediate stages.

Add a reject link to your Oracle Enterprise stage or Oracle Connector.

Use the Performance Analysis tool to identify the bottlenecks. It may be that your bottleneck is not in the I/O subsystem at all.