DSXchange

Write your own custom routine.

As soon as Craig mentions "and" as an exception you will realise that you need more exceptions, such as "or", "etc." and so on. The list of exceptions is much more easily handled by a custom routine.

Yes, for some interpretation of what "work" might mean.

As a test, replace your target(s) with Copy stage(s) that have no output.

Slowness of links into database stages is typically a problem at the database end rather than at the DataStage end. The above test will prove this.

You did not answer my question.

A job sequence (consisting solely of job activities linked one after the other) compiles to exactly the same Job Control routine as a Batch or user-written routine.

Probably not, but not all errors are accurately reported, and we've reached the "clutching at straws" phase.

Is there anything useful in the Teradata error documentation about this particular error code?

How about the codes (CHAR(4) and CHAR(5))?

I expect that this is not a limitation of the data type but of the maximum bytes per row that the ODBC driver can process.

In the uvodbc.config file parameters such as MAXFETCHBUFFSIZE can be used to increase (or decrease) these values.

Is that an interview question?

Have you read the pertinent manual (Connectivity Guide for Oracle Databases)?

"Overflow" suggests that the data are too large to fit into the designated CHAR or DECIMAL data types. But you wouldn't do the CAST in reading from a Data Set. I can't see how duplicates would generate this kind of error message. Is P_EIW_W_T_UTILWORK_01.dly_cust_acct_drv_E2 a table or a v...

By LookupFileSetprevioussource I meant the job that populated the Lookup File Set. The Lookup File Set stage itself does not support stream output.

Much slower than what?

How do the expressions in the CSV file differ from the successful expressions you were able to create in FastTrack?

If the answer to that is that they're identical, then you have found a bug in the importer which should be reported to IBM.

If they have maintenance, the upgrade is free.

Read all of my response.

Premium membership is not expensive, at less than 30c (Rs12) per day.