DSXchange

Of course not.

Unless you give us some clue about what "optional feature" you are relying on by posting your custom SQL we are totally in the dark.

Maybe you can use ODBC tracing to determine which SQL function caused the error to be generated.

Have you undertake a Search of DSXchange to find the steps? I'm sure they've been documented here somewhere in the past.

The only disadvantage is the need to preprocess your data to write the range map used by the partitioning algorithm. Along with this goes the need for a standard naming convention for your range maps so that the correct range map is associated with particular sets of data and the range map for one j...

Put ALL of the database environment variables into your project (in the Administrator client), and use environment variable job parameters to override the value (as required) on a per-job basis.

DS.REINDEX is not a "magic bullet" and should rarely need to be used without some cause being checked for. Therefore it is not a good candidate for any "automatic maintenance" script. I feel that your energies could be better directed elsewhere. That said, of course it can be done by invoking the us...

Welcome aboard. The concept of "active" and "passive" does not really work well with parallel jobs, since every operator potentially creates its own process - definitely true if operator combination is disabled - and all of them can be monitored. The usual reason for including an active stage in ser...

There are no implicit conversions, since there are no data types in server jobs. So, yes, you can use just substring. If there are guaranteed to be two decimal places use

Do you have the database environment variables in your Administrator client (that is, in the DSParams file for the project)?

Only dsjob as far as I can ascertain. And, yes, this answer implies that you have a DataStage job designed and compiled that will move the data as required.

That is probably not going to help.

You can not delete a category that you're working in, in exactly the same way that the operating system won't allow you to delete a directory that you are working in. Or that anyone else is working in at the time.

That's how default handling of non-zero exit status works. To override it handle the "failure" condition explicitly with a trigger.

Use a single column key, perhaps made up from the concatenation of the two fields plus a separator character.

In version 8 there is a world of difference though, ultimately, the same result is achieved. In version 8, as you are probably aware, QualityStage and DataStage share the same Designer. But the differences are much more deep-seated than that - the four principal QualityStage tasks (Investigate, Stan...

File name or file pathname?

DataStage probably does not execute in the same directory as the one in which you execute the script.

As always, IT DEPENDS

Mainly on the total amount of resources the system can deliver and the total demand for those resources for all currently running applications.