DSXchange

Differentiate the detail records types in a downstream Transformer stage.

Have you changed the First Line is Column Names setting?

They don't provide the same output. Look at the other fields that are output, rather than focusing only on the ChangeCode.

How have you defined where the data files ("segment files") of the File Set are?

Should the passive stage that has two output links have one of them converted to a reject link?

Try using ODBC stage for SQL Server.

Not really. Which environment variables are different between development (where I assume you regard performance to be satisfactory) and production?

Welcome aboard.

One way is to execute the remote job via the dsjob command in an Execute Command activity in your sequence.

Use the Permission tab in the Project Properties of the Administrator client.

Do a pencil-and-paper test of a couple of values. The problem with your logic will jump out at you.

Read about DSGetJobInfo() in the DataStage BASIC manual. There are different options to return different sets of stages; the default gives only the active stages. The dsjob -lstages command gives effect to this default. You can always modify the dsjob code.

StringToDecimal is not part of the DataStage BASIC programming language - it belongs only in parallel Transformer stage expressions.

The order of columns is irrelevant. They are accessed by name.

James's questions are pertinent, for all that you seem to want to avoid them. For example 22 million rows can be quite small (for example two bytes per row) or huge in terms of memory demand. But you do not provide guidance, even though memory demand is the principal determinant of what I believe yo...