DSXchange

The .odbc.ini file is usually in the DataStage Engine directory. Its location is usually stored in the $ODBCINI environment variable.

Don't try to (implicitly) shoehorn a potentially 255-character string into a 2-character string. Your input is VarChar(255), your output is Char(2). DataStage alerts you that such is the case.

Are you volunteering to spend the 100 hours it takes to script one hour of video?

Moderator: please move to parallel forum

In the column definition the size of the vector on the output from the Transformer stage is different from the size of the vector on the input.

Simply remove the links. The jobs will then run at the same time.

Triggers are not checked until the job (or other activity) finishes.

What is the problem that you are having?

The expression is syntactically correct. The key columns will not be null unless the lookup fails (a lookup is functionally a left outer join).

There is a UNIX-based ODBC driver for SQL Server that ships with DataStage, but no mechanism for accessing the loader from UNIX.

So Craig's initial thought is the likely solution that you will need to implement.

Sure is. It's called QualityStage. There are "over 24" probabilistic algorithms, though that estimate is from marketing I suspect. Nonetheless the range is good, including number/date plus or minus, string matching allowing for omissions/transpositions, match if shorter string matches, and so on. Pl...

Did you initialize the state file?

Pipeline parallelism is implemented using inter-process row buffering. Partition parallelism is implemented using either Transformer or Link Partitioner stage to partition the data and Link Collector stage should you need to collect the parallel streams back to a single stream. In short, in parallel...

You don't need to specify number of readers per node - that's why it's an option. Its default value is 1. You should only need to increase it to read very large files in a smaller amount of time, but not so fast that you flood the next operator downstream.

I'm uncertain what the Heisenberg effect is - can you please amplify?

WINNTRemote won't help - you're on local Windows. However, I wonder about whether QualityStage (which is a 32-bit application) will run successfully on a 64-bit version of the operating system. Please ask your support provider.

This error is being generated by the driver. You should contact Data Direct (the supplier of the driver).