DSXchange

What do the jobs do? In particular do they access data over a network? Have you checked that the network might be the bottleneck, because everyone's downloading videos on it?

You've just reinvented the MAXIMUM() function.

No. You can represent NULL as a space if you like, but transformation is done in the Transformer stage.

You simply don't have enough data to fill one 128Kbyte block, much less eight of them. DataStage moves data around in buffers of at least this size. That's why they're all in one place.

Check that every folder in the pathname exists and that there is at least one csv file in the final folder. Otherwise DIR will return a non-zero exit status. It's clear that the parameters are being resolved.

See your other post on SQLError().

In particular, the third argument thereof must be a statement handle.

Use a reporting tool.

DataStage is an ETL tool. DataStage is NOT a reporting tool. Never was, never was intended to be, never will be.

Details are to be found in the UniVerse BASIC SQL Client Interface manual.

That's reporting the location of the source and object code from a server Transformer stage.

Moderator: please move to server forum

*Moved! - Content Editor*

Follow the Installation Guide, noting that Windows XP is not a supported operating system for the product.

No. That's why I used the word "before".

I don't think that's true (if it were, it wouldn't have an "@" symbol in its name), but USER is an environment variable in most UNIX systems.

The requirement for \; is true in the shell also. It's not a DataStage issue. The reason is that semi-colon is a shell metacharacter, which means that a new command is beginning. You can also use && as a command separator. This requires that each prior command completed successfully, but tha...

If link.B is null then (link.A = link.B) is null. The rule in server jobs (in DataStage BASIC) is that, if the test expression is null, then the Else path is taken, on the grounds that one can not assert that null is "true". The Else path is taken if the expression is not true (which is no...