DSXchange

Such as a parallel routine invoking the DSCAPI function that I mentioned?

It's the Terminator (obviously you're not a resident of California).

Search is your friend. You are not the first to have asked this question.

I have strongly-held personal views on this topic, given that DataStage is a metadata-driven product, so will not seek to impose them on this discussion.

You obviously have a RMM stage! I can't read that into the requirement.

Is there any message in the log about Type 30 table full? This means that your T30FILE setting (in uvconfig) is inadequate for the number of dynamic hashed files that you are trying to open system-wide simultaneously. Remember that the Repository tables are also hashed files. Increase the setting of...

Duplicate Post

Please reply to other thread.

You can mark job 3 "do not checkpoint run" so that job 3 always runs.

A CASE clause within the SQL would seem the obvious way to go.

... which tells me you were not doing an -itag installation. Without this it is impossible to run two versions of the server on the same machine.

To which database are you referring? DataStage must have its own database, called the Repository, co-resident. You don't get a choice on this. But any database that you are accessing for data and metadata can be anywhere accessible from the DataStage server; in particular it does not need to be co-r...

What are the constraint expressions for the two links in your Transformer stage? What is the derivation expression for your flag (the actual expression, not what it does)? What, precisely, is the problem that you are trying to solve?

There's no reason descending order should not work, provided that you really have specified partitioning and sorting exactly the same for both links, or Entire on the right input (which carries almost no penalty in an SMP environment). What do you mean by "does not work"? Are the appropriate columns...

dsjob has an option called -import that you can use. Type just dsjob -import to get the syntax.

You still need to understand its structure. If you have that, then you can create a record schema and would be able to read it.

You can also read it as a single column of type raw, but there's not a whole lot you can do with that.

You can not control links in this way in a DataStage job. A job is the unit of execution, not a link. You will need a more modular design (more jobs) if you wish to exert this level of control. If you are referring to a job sequence, however, you control the behaviour using Triggers. Don't ask us ho...