DSXchange

In the "old" documentation, it was in the Director's Guide. Not sure if that's still the case in the 8.x world.

I'm going to take a wild guess and move you here. Please go back and edit your original post to add the information Ray mentioned. If we're still in the wrong forum, I'll just move you again.

It could also help to explain what "doesn't work" means.

Nobody said it would be a warning or an error.

Next step? An exact search here for "Fault type is 11" since you're not the first to experience that particular error with the Merge stage.

No, there's no View Data capability in that stage which is why it is disabled. Ray was asking in an attempt to stop the aborts, not make it so you can view data.

So, what was your actual resolution?

Sorry, but you can't simply rename an xls file to ".csv" and then expect to be able to read it.

Seems to me you'll need to set a high threshold on the loop (since you can't know when it will end) and then specifically exit the loop when your condition is met.

Pretty much what you would think. Carefully check your data sizes versus the size declared in the job if the reject is from DataStage. If the message comes from Oracle, compare to your actual table's column sizes which may not match your job's metadata.

As long as you understand the differences between the two - link counts versus actual record counts - you can certainly build any sort of logic you like around it, business or otherwise. You have to account for rejects plus how updates/deletes count versus inserts, it is the former that tend to conf...

Which is what I assumed they were doing when they said:

tanmaya wrote:I need to use $projdef settings for the 3 environment variables, but pass the value of job parameter while using dsjob command.

But I guess we shall see.

Make sure you are referencing an active stage in the call, i.e. a Transformer when you check the link for row counts.

Call it before or after job as appropriate and pass back a non-zero return, the job will notice.

Define "add" in this context. You need to do math on them? :? If you mean access an xls file from DataStage, on a UNIX server that would require specific ODBC drivers be purchased. Most people save the xls as a csv and then transfer it to the UNIX server where it can then be accessed by th...

Post the syntax you are using and the error(s) you are getting.

ps. I moved your post into the General forum and edited your subject (slightly) as dsjob is "job agnostic" and works exactly the same regardless of job type.