DSXchange

That is also in the documentation (for version 7.5 Parallel Job Developers Guide page 2-32), and depends on the precision settings. Range depends on precision also; a decimal with precision N can contain no more than N digits.

Do these managers have pointy hair, by any chance? How big are the rows? Can TPump, running standalone, achieve these benchmarks? (If not, then clearly DataStage driving TPump will not be able to. Don't sign up for anything doomed to failure - push back against unrealisitic demands - the more accept...

Please advise in what manner this post could be described as a DSXchange Testimonial.

Then post in the correct forum!

Your question is more likely to be answered once you have done that.

Let's solve the problem of why you can't log in using Director.

What error message is emitted?

NEVER use kill -9 on a DataStage process!

Is Oracle on the same machine as DataStage? In any case, there is one process on node 0 executing the operator associated with the Transformer stage, and another process on node 0 executing the operator associated with the Oracle Enterprise stage. They communicate through a pipe. There are two commo...

What are the column data types when you import the table definition into DataStage? DataStage does not support a data type called "byteint".

I initially thought that, but the message was specific about a backslash.

Fair enough. But you could have built the whole thing in a custom stage (possibly a Build stage).

That's probably because both the SQL CAE Access Group standards and the ODBC standards specify single-quoted string literals.

Wasn't much of a browse, then. This question has been asked and answered many times. Do an all terms search on SIGSEGV and operator terminated. There are very many possible causes of SIGSEGV - you have to do some detective work to eliminate some of them.

The File Name Column property must name a column that occurs on the stage's output link. This column should be a VarChar large enough to take a full pathname, for example VarChar(128). And, needless to say, the column must appear on the output link.

Just do nothing. Let the float number travel through your job. The scientific notation display is merely an artifact of the data browser. If you need to convert this to decimal, make sure that the decimal data type has a precision of at least 18 (six digits in your number and twelve in the exponent)...

Why did you bother? Except for sparse lookups, DataStage loads the entire file (data set) into memory anyway for the reference input to a Lookup stage.

You may also need to edit your CLASSPATH environment variable.