DSXchange

"7 key columns that make unique for each row" only helps if there is an index over those columns, or at least an index where the leading columns include as many of these as possible.

Is that the case? Otherwise, each update results in a full table scan.

Ah... I thought that was '000'. Avoid! Avoid!

(Funny, but I heard your advice in a Dalek voice in my head)

Off the top of my head, the FMT function can round to a specified number of digits. You can also just move it to a field defined with a scale of 0, I would think.

128 throws what kind of error? At runtime or compile time?

You need an "include" statement so the compiler knows they are not just arrays in your code:



A Search for your error "Array 'DSAttachJob' never dimensioned" would have easily turned this information up.

Either use a delimiter that won't be found (and you need to determine it) or enable the Suppress row truncation warnings option if you believe that the found delimiter comes after all your data.

Already tried to explain all that, Vincent, but it didn't seem to help.

Add a job parameter to indicate the number of records to skip and a constraint to skip them until @INROWNUM is greater than that value.

I don't really use them but don't see the point of doing so all in a single job. You would typically setup 'reader' and 'writer' job(s) to leverage your pipes, AFAIK.

Compare the two directly as strings. Use the substring operator [] to hack off the first ten characters of the timestamp when you do:


Or Field().

Interesting... sounds like it has growed up quite a bit since last I looked at it. From what I recall, many of the connection options you have (like for failover) are specified in the tnsnames.ora file. Found this online for Oracle CM but it seems to do a nice job of walking you through a RAC setup....

As I noted, from the command line, meaning directly from the operating system prompt.

You missed all of the '%' markers:

Yup. Have fun John!

Time to involve your official support provider, it seems, if you haven't already.