DSXchange

If you ever get a change to view the native source code, you would be amazed at how close to the ODBC API some of them are!

Though not all.

Remove NLS is not possible.

Remove NLS during upgrade is not possible.

Uninstall 7.1 and clean install 7.5 without NLS is definitely do-able. Then import the projects from the exports that you always take (right?) before upgrading anything.

ODBC and OCI are comparable at low-complexity SELECT. They are greatly different at INSERT and UPDATE.

The ultimate reference is BCI Reference Guide. This mimics the ODBC API. You will need a licensed ODBC driver to connect from DataStage routine.

I just had a report from a customer as follows. Job design is There are 34756 rows to move. Array size is set to 1000. The job loaded 34000 rows, and apparently discarded the incomplete array.
Further investigation is required.

Complexity serks.

Set NLSMODE to 0 in uvconfig, regenerate and restart DataStage.

Why not install 7.5 without NLS entirely?

That will be very handy to know, until "they" fix it. Hopefully that will be soon.

Try 4000. If that gives truncation errors, double it until the errors go away.

Process them in separate jobs, run consecutively, with the writing rule set to Append.

Create a stage variable, say svNullCount. Initialize it to 0. Derive it as If IsNull(InLink.ColumnName) Then svNullCount+1 Else svNullCount Because Boolean functions return 1 for true and 0 for false, a simpler - and more efficient - derivation is svNullCount + IsNull(InLink.ColumnName&#...

Oracle is complaining that you're specifying LongVarChar(0), since "" is treated by DataStage as 0 in a numeric context.

What was the maximum length (precision) when you imported the table definition from Oracle? Use that value.

If you read the ODBC specification for the Excel ODBC driver you will see that it requires that the worksheet has column headings and is otherwise in tabular format. That is, there is no scope for header and trailer rows. Can you pre-process the worksheet (perhaps into a worksheet with a standard na...

Reporting Assitant is deprecated (= no more development or fixes). It doesn't handle job sequences. It doesn't handle shared containers properly. It doesn't handle the DRS stage properly (which generates errors something like what you report). "They" say that the replacement tool of choice is MetaSt...

Setting the ErrorCode argument to a non-zero value to stop the job is actually documented in the generated before-after subroutine code.