DSXchange

Pretty simple - index the target table over whatever fields you have as 'key' fields in your update link. Without them each update is a full table scan of all 12 million records.

You can always drop the index when this is done.

Are you searching on the DataStage server? Do you know where your DSEngine directory is? There should be a "bin" directory under there with all of the appropriate executables in it, I would think.

Yes & Yes. The DOS command to delete a file is "del" or "erase".

I'd lean towards 3. And that kind of 'sql' don't need no commit'n.

Did you try a simple Windows search? Nowadays I would look for (and use) "dssh" rather than "uvsh".

In an Execute Command stage do:

echo "Production ran successfully" > YourFilename

In other words, a search for the message here should provide you some inputs so that this error can be resolved.

You could probably do an implicit conversion, or explicitly using the DecimalToDecimal() function. Keep in mind the fact that you are going to get warnings whenever you do something like this, sending a larger something to a smaller something as it won't necessarily fit.

First question - did you search for your message? An exact search here for "the source decimal has even precision, but non-zero in the leading nybble" turned up 14 matches, several of which were marked as resolved.

He knows what the message means and has stated that the sql to disable the constraints is in the Before SQL tab of the Connector. So it's either not running it or it is failing and not logging that fact. Never used the stage nor have any access so can't help directly. Is there anything in the log to...

Where exactly are you calling this - before or after what? After job you won't be able to use stage variables, so can I assume after stage with that stage being tjhe transformer where you declared the stage variables? :? And you call it with one parameter, the one you called 'JobName'. ErrCode is re...

OK... then I guess we really are resolved here now.

Same way.

What are the data types you've used for the columns in the stage?

Do an exact match search for "Oracle client version 0 is NOT supported" and see if any of the previous posts that mention this same problem help.