DSXchange

nevermind...

found that it does not trap errors when running in parallel but it does when running in sequential.

I'll open a case with ascential.

more info...

-The write method of the Oracle stage is "load"

-Neither the flat file nor the Oracle stage support reject links

-reject mode = fail does nothing

I must be missing something obvious because it can't be that uncommon to want a job to fail when the SQL loader fails.

I have a job that loads data from a flat file into oracle. Datastage generates an SQL*Loader to perform this. Problem is, the logs in director show that all the records have been processed (and all lights are green) although half the records are invalid and didn't load because of not null constraint...

I am having a problem using the row generator. I have the simplest possible job that is composed of a row generator and an Oracle stage. It inserts 9000 rows to a staging table and it works fine. When I set it to 10 000 row, it dies with the following error message : write() failed: Broken pipe I am...

That worked. Thank you very much, you are a life saver.

Can you tell me where that syntax is documented ? I could not find it anywhere.

Did some more tests...

When I run 10 instances of this job, I get anywhere between 3 and 6 successes, it's never consistent.

seems buggy to me.

I'll log a support call I think.

Hi everyone, I absolutely cannot figure out how to run multiple instances of a job. What I actually need to do is more complex than this example but for the sake of argument I made the simplest possible job I could think of and run multiple instances of it. Here's what I did : Created a job that rea...