DSXchange

INTBIN and QRESPATH are environment variables that you should have set. The reference to {AN} strikes me as odd, since there isn't one in your override. This one may be a bug. The same is true for the "vacuous operand" error - I can't see a backslash in your override specification. Involve your supp...

Have you distributed/shared the required files? You may need to refer to the DataStage installation guide for this - I don't recall that it's at all well coverted in the QualityStage manuals. (And I don't currently have access to them, so can not provide greater detail.)

Any constant value can be replaced by a job parameter reference.

Try user-defined SQL of the form where job parameter jpPartitionDate is of type String and contains the replacement value, for example "sep_07_2007"

Often when a SIGSEGV signal is raised, there is a core dump. The message provide addresses; you should be able to analyse the core file with a suitable tool such as dbx.

Define "performance" in an ETL context. Unless you have a definition of performance, you can not define metrics with which to measure the performance, and therefore can not claim to have improved or worsened performance (whatever that is). Get parallelism happening as early as possible. When reading...

How about introducting a Modify stage into your design to switch the nullability explicitly?

APT_FileImportOperator is the class from which Import objects (such as the operator generated by a Sequential File stage with an output link generates) are instantiated. The most recent error message indicates that the wildcard handling is not finding any files matching the E:/test/*.txt pattern. Wh...

... or use Debugger or stage tracing to figure out what value was sent to email_body column. There used to be a bug in ODBC (2.0 from memory) where too long a string for the max length of a VarChar would exhibit this kind of reporting behaviour. However, on closer inspection, I note that the error m...

That's DB2 version 9 or later, Oracle version 10.g or later, or SQL Server 2003 or later.

Supply a value for email_body.

The APT_Communicator class is used mainly (only?) for communication between player processes, which basically means when repartitioning is going on. Perhaps you could try to reduce the amount of repartitioning that is occurring in your job design.

That was "school mascot and CANNON".
At least get your imaginary facts right!


U2 University finishes today, at the end of which I'll mark this thread as Resolved. Even though it did wander a bit.

What else was happening during the API test?
Was the DB2 Enterprise stage set up to use direct read or SQL?

You might be conservative, but DataStage is notoriously profligate.