DSXchange

Before dumping the CSV file, select the date columns and choose Format Cells to specify a consistent date format. You may need to specify a Custom, rather than a Date, format, for example "mm/dd/yyyy" (or why not "yyyy-mm-dd"?).

Obviate your problems at source.

It's mainly a functional question. Do you need direction of difference? Then you use the Compare stage. Do you need the source columns separated (Difference) or as subrecords (Change Capture)?

Was that a reject link from the Sequential File stage or from the Lookup stage?

I suspect the latter, but we're trying to help future searchers here.

You don't get off that lightly!

Was it PATH or LD_LIBRARY_PATH ?
Which was deficient, and what was missing from it?

Please post the working PATH and LD_LIBRARY_PATH values (you can use set | grep PATH to capture them).

Too rushed, grasshopper.

Take the time to smell the flowers.

Meditate for a while. Ponder the questions.

Didn't notice the promised Errors manual among that lot!

Are you trying to assemble a composite key with a "|" between them? This is not the right way to perform a lookup against a data source that has two keys. You must provide separate values for the separate key columns. Please advise whether this is a server job (as marked) or a parallel job (as poste...

Can you take a look at the generated sqlldr control file to see whether it contains a "nocheck" directive and, if so, whether it's in a syntactically correct location?

narasimha wrote:You can add up the Tracing levels to give more information.
7 gives combined tracing information.

So does 5 mean 1+4 or 2+3 ?

Perhaps they are cumulative instead?

Normally additive codes are given as powers of two, so that all sums are unambiguous.

Can you be more precise about what the source of the value is? Are you going to extract a different value from each partition? Is it once per run or once per row? What value(s) do you need to be supplied to the second job (presumably as a parameter value)?

For the load part, can you not simply append sufficient fractional seconds digits? Something like: Field(InLink.TheTime, ':", 1, 2) : ":" : Fmt(Field(InLink.TheTime, ":", 3, 1), "8R5##.#####") (This form will work with both times and timesta...

The easiest way to collect them to a file is to go to Director log view and set a filter so none of the green icons appears (de-select Control and Information messages). Then choose Print from the Project menu, and within the common print dialog check the Print to File check box.

Nah. It's not between the lines. It's out there in your face. The catalog name of the routine is at the core of the error message.