DSXchange

You can code for this explicitly with a Custom trigger of the form JobActivity.$JobStatus <> DSJE.RUNOK - send this link into a Routine activity that invokes UtilityAbortToLog().

Upgrade to DataStage version 8.0, where there is better integration with the DB2 version 9 data types. The XML data type is new to version 9 of DB2, so was not known about when earlier versions of DataStage appeared. Whether the new functionality extends to server jobs I am unsure.

Try ISO-8859-1

Not possible in server edition without some form of pre-check - either in a before-job subroutine (but you still only have the option to abort the job) or in a controlling job sequence.

You can also click on the "open book" tool on the toolbar, choose Log from the View menu, or right click on the job and choose View Log from than menu.
Invoke the filter using Ctrl-T or from the right click menu.

There is no END statement, but there MUST be an ELSE clause - the expression MUST produce a value whether its test expression is true or not.

Define "performance" in this context.

Rows/sec is meaningless. A well-sized hashed file will best handle the volume of data for which it is tuned, or a subset thereof. But it will still efficiently handle larger volumes, by automatically managing its "table space" - hence the name "dynamic".

... and that incremental count is the row count for rows processed thus far, which is apparently what you seek. In the final row it will contain the total number of rows processed by that Transformer stage. You can run it through an Aggregator stage with its "Last" aggregate function to get a single...

YOU don't need to use sqlldr in automatic mode, but the stage process does invoke sqlldr (automatically). The implications for Oracle client software and environment variables should therefore be apparent.

Why have you set the array size so large? Array size is the number of rows sent at a time. Therefore, until that many rows have been processed, no rows will be sent. But the clock is running, so your rows per second (a totally meaningless metric - search the forum for reasons) will be severely under...

A great start point is developing a business glossary - centralizing (and getting agreement upon) the definitions of business terminology. Only when you have this in place, and agreed to, does it make any sense to go forward with designing a centralized model. I suggest that you look at IBM's busine...

If your symptoms are as Eric describes, make sure that umask is set to 002 in dsenv, and that both users belong to the group associated with the project directory.

Is this for all plug-in stages, or a specific one? If I read that description accurately, it says you can set it to whatever you like, but an array size of 1 will actually be used. So your setting it to 1000 has possibly simply been ignored. Perhaps you could have your DBA trace the operation to det...

How did you try to override the auto-purge parameters with a "date"? Do you mean "number of days"? Did you check the "Enabled for this job" check box?

Welcome aboard. :D In your job parameters add $APT_CONFIG_FILE (use Add Environment Variable). Set its default value to the special token $PROJDEF. Change this parameter value when submitting a run job request to choose the configuration file that best meets the job's needs. And, obviously, organize...