DSXchange

Does your Oracle Enterprise stage have a rejects link? If it does, I would expect DataStage to log an alert message if it is used. The reject link should also be able to deliver sqlcode automatically so you can determine why the row was rejected, at least generically.

Retrieve its value using DSGetParamInfo() function.

There is, of course, another compilation option in the sequence, to log a warning if any activity finishes with a status other than OK. If this option is selected, and an activity finishes with a status other than OK, then the sequence simply can not finish with a status of OK (Finished).

You specified a relative pathname (no leading "/") and DataStage gave you a pathname relative to the project. You need to provide a fully-qualified pathname to avoid this default.

1. Don't shout. All upper case is regarded as shouting and is offensive.

2. Can you please be clearer about your requirements. I have no idea what the numbers mean. Use code tags to preserve spacing.

3. I doubt that any looping will be involved.

Is your LAN very busy?

I recall once working in India when everything became very slow. It turned out that nearly everyone had decided to watch the World Cup cricket live in their browsers. There was no bandwidth left on the LAN.

With a two-node configuration file: a configuration file that mentions two node names with associated resources for each.

The doubled slash character in the master document pathname may be at fault.

Look at it from the other end. When a table changes, select that table definition in the Repository and perform a Usage Analysis to answer the question which jobs touch that table definition.

You are meticulous with your metadata management, aren't you?

Since DIR is an internal command, the only way it could not be found is if the operating system of the server were other than Windows.

I wouldn't bother, because this is easy to do in a Transformer stage. Simply select all the columns on the output side, right-click the selection, choose "Derivation Substitution" and put Trim($1) into the substitution dialog. Voila!

There's good news on the horizon. In a future release IBM will add High Availability (HA) capability to the unified metadata repository for Information Server and the WebSphere Application Server, allowing each to run on clusters with failover capability. HA can reduce the probability of needing to ...

Change the command to detect file size and perform the grep conditionally upon that.

Depends what you're doing. For example, if your settings invoke sqlldr then the errors will be in the sqlldr log file (the bad file may also be populated). Once sqlldr starts, control has left DataStage, which simply waits for sqlldr to finish. Put another way, sqlldr does not emit its errors on std...