DSXchange

Surely if you can use the CFF stage as a target you don't need to effect any transformation?

Use DS.CHECKER command to verify/clean up partially deleted jobs.

Stop wanting to have your cake and eat it too. This is not a DataStage thing. If you want all rows to be in one transaction, then that's that - if you can't feed the rows swiftly, then the transaction will take a long time. It's simple arithmetic. If you want speed, then remove your other restrictio...

Run stopped after 100 rows can only be caused by one thing; when the job run request is issued, a limit of 100 rows is imposed. Check the Limits tab on your Job Run Options dialog.

All inputs identically key partitioned (hash probably, or modulus if integer), identically sorted, and update inputs de-duplicated.

This message (about Data Sets) sometimes happens when the compiler is not properly installed or licensed, or the licensing on the compiler has expired. Can you please check whether either of these situations obtains?

If a job control process has failed, you might try resetting it in Director, in case any additional diagnostic information "from previous run" is logged as a result. It may, of course, be an operating system limit that has been reached; your system administrator ought to be monitoring things like th...

Not looking for loopholes; attempting to narrow the universe of discourse so as to provide the most apposite answer.

... and what has that to do with the topic of this thread?!! Please do not hijack other people's threads - start a new one when the topic is different.

DSXchange does not connect to Netezza.

Please post your question in the correct forum.

There are no rows in a hash file. In a hashed file, however, there may be. Set up a VOC pointer to the hashed file (search forum for SETFILE command) and use a query such as SELECT COUNT(*) FROM hashedfilename; to obtain the actual row count. The link row count reports how many rows were sent but, i...

prajish_ap wrote:Can anyone please tell me what this trim function actually does?

Trim(oconv(date(), 'DMD[2,2]')," ","A")

Nothing at all in a parallel job.

There is no version of DataStage for AS/400, so their "decision" is fatally flawed.

In an SMP environment the BASIC Transformer stage is capable of parallel execution. (Of course you still have the overhead of translation to and from the typeless environment.) Short of a stage-variable-based solution, or writing your own C++ equivalent of the server function, I can't envisage any o...