DSXchange

No, that's the Aggregator stage, not the Pivot stage.

Can you find it in the Stage Types \ Parallel \ Database section of your Repository?

Did you check the install log to determine whether or not it was installed?

I don't know how it works. Some very clever engineers who wrote the Teradata Connector stage figured out how to get Fastload to append to a non-empty table. That much I learned at an IOD conference, but not the underlying mechanism.

Param.ini is not part of DataStage either. So it's been created in-house at your site, and that is where your search for documentation must begin.

Which after-job subroutine are you using? Check out its source code, and learn how it handles the exit status of the executed command. To have the job abort, the ErrorCode argument must be set to a non-zero value. Make sure, too, that the after-job subroutine is actually being executed; for example ...

That doesn't really alter my thinking, although it would have been good to have mentioned that in the original post. Whatever SAP is doing to produce these results, it is taking more than 2 minutes to accomplish it. Hence your 7200 second timeout and hence your 0 rows delivered. Does the request req...

Probably a difference in data volumes in the different environments.

Only if you have an ODBC driver can you use the ODBC Connector stage.

Open/create a parallel job. Make sure the Palette is visible (if not, use View menu). You should find DB2 Connector (as DB2 UDB with adjacent dropdown) in the Database folder of the Palette.

If it's not there, verify that the installation of FP1 was totally successful.

Other than fiddling around with escaping either the quote characters or the semi-colon character I have no suggestions. Perhaps you should involve your official support provider - this seems to me like incorrect behaviour.

Bulk load uses whatever you specify in the Load Type property when Access Method is set to "Bulk". This can be "Load" (Fastload), "Update" (Multiload) or "Stream" (TPump). The Teradata Connector stage can even use Fastload if the table is not empty. For more i...

Can you insert this string using Teradata SQL Assistant, or some other client?

That is, is it a Teradata restriction or a DataStage problem?

As noted, you can also get drivers from database vendors and third party providers. Since you've bought QC you may be able to get HP to provide one without charge.

Every link in a parallel job consists of a virtual Data Set.

You can see this in the generated OSH and in the score.

You can also change the licensing with a uvregen command - it requires four command line arguments to match the new licensing information.