DSXchange

You can handle them however you like. Job sequences have one form of automatic handling built in, but the Exception Handler merely initiates a separate stream of processing - you still have to decide what to do. Doubtless there are some business requirements that will guide you. Who needs to be told...

You need to specify that the file has fixed width format.

You should be able to get them (for the asking) from your vendor. For anyone else to provide them would probably violate their licence agreement.

Are you saying that you want to do this from DataStage TX (transformation extender)?

As far as I am aware there is no-one in my part of the world yet using QualityStage version 8.x, at least not in anger. Some POCs (proofs of concept) are about to happen, however. Could be interesting.

Surely you should be asking Microsoft, particularly if the answer you require is "yes".

Note: This function (Trans()) is available in job sequence expression derivations, not in parallel job expressions. The OP specified job sequence.

The function is documented in the DataStage BASIC manual. It does the same job as UtilityHashLookup() but far more efficiently.

The import dialogs ask for server name and other authentication information. Just do them one at a time, correctly pointing to the correct server. You may have additional issues if the servers are, for example, running different versions, but you made no mention that this is the case, so I won't bot...

Two jobs. The first one checks for errors and loads the result into a staging area (a text file would do). The second loads from there into the target table, but is only executed if the first succeeds (reports no warnings or errors). That control you can institute using a job sequence containing two...

Does not the ODBC stage also support Transaction Grouping?

Bottleneck. No parallelism. Need to call server routine from parallel job - not impossible, but a bottleneck and a performance inhibitor.

fmartinsferreira wrote:We have a job that worked and now doesn't work anymore.

What has changed? Something has.

What is your default date format string in DataStage?

Anything that can leverage indexes do in the database. This can include restrictions, joins, some groupings and sorting (if there is a B-tree index on the column being sorted).

Here DSJobName is a macro.