DSXchange

Please post the pertinent entries from .odbc.ini file and uvodbc.config file, as well as the complete and exact error message. Also include in your post how this error occurred - was it during View Data, a job run, or somewhere else. Equipped with these facts we will be more likely to be able to pro...

Research the Oracle HEXTORAW or RAWTOHEX functions (depending on the direction - into or out of Oracle).

The crucial bit appears to be "capture". Does that mean "read them from a file"? If so, by what thought process are they being called "parameters"? Are they "job parameters" or something else?

You can get various UNIX environment tools for Windows, some free. All of these will have a split command.

KEY is, of course, a reserved word (PRIMARY KEY, FOREIGN KEY). Therefore to use it as an identifier, such as a column name, you need to enclose it in double quote characters.

Who is the manufacturer/vendor of QAS ? What does it purport to do?

Failed to allocate environment handle is typically indicative of one of two things - that the server does not have enough memory to undertake setting up an ODBC environment, or that the ODBC driver manager could not be found. These, therefore, should be the first areas that you investigate.

Excellent research. Thank you for posting the answer.

It uses a lower level call than that, probably fopen() - but I don't know for sure.

It's the same - detect that 0 rows were sent, and write zero.

Set the Aggregator stage to run in sequential mode and to use Sort/Merge collector.

Have you added the environment variable to the job as a job parameter? Usually when the unresolved reference appears in an error message like that, it means that the job parameter does not exist or has been mis-spelled.

Modify stage uses zero-based counting.

Nothing wrong with Transformer stages (these days) either.

Welcome aboard.

Surround your job parameter reference with "#" characters, for example

There is a very easy solution if you're prepared to use a server job. Make the target stage a Hashed File stage and choose Type 19 when creating it (or simply do nothing if the directory already exists). A "Type 19 hashed file" is actually a directory, and the record IDs (Keys) are file names in tha...