DSXchange

As Kim said, your quotes are getting messed up. You need to take control of that. You also may need to take control of the fact that, when opening a new shell, DataStage does sometimes strip a layer of quotes - you may, for example, need to "escape" your quote signs.

And, if they're not set up in dsenv, you need to make sure that the environment variables APT_CONFIG_FILE and APT_ORCHHOME are correctly set.

You need to specify the "link field" property (in Available properties to add). This link field provides the value on which the size of the vector depends.

There is a clever solution using three consecutive Sort stages. I'm on vacation at the moment so can't check details. It's a technique that is (or used to be) shown in the IBM Advanced DataStage class.

Get the month from the date (a TinyInt from 1 to 12), add 2, divide by 3 and take the integer part (that is, use the Int() function).

Add 4 for each year beyond the current year.

Yes. Obviously. The orchadmin command requires at the very least that the environment variables APT_CONFIG_FILE and APT_ORCHHOME have been set correctly. Yours have not been.

The approaches thus far seem to be overly complex. It seems to me that there are two separate things to solve: removal of the sign and checking of the structure. Use Convert() or Abs() to strip the sign. Test that result. You could use IsValid() to test for Decimal(7,3) or you could convert to strin...

Presumably the export utility has quoted these strings. In the Columns grid (and I note that this is a server job, even though posted in the Enterprise Edition forum) you can mark the column(s) in question "contains line termintors" in the Sequential File stage and everything will be taken...

Congratulations on your pass. I also obtained that certification at IOD 2010, on the Monday. I wasn't aware that the exam would be available, but took the opportunity in the Demo Room to get briefings on all the new functionality in version 8.5. That, plus my extensive experience with the product, t...

Moderator: please move to Enterprise Edition (parallel) forum

This question is not a suggestion for a topic in the FAQ forum.

Options folder, Available properties to add.

We need to tighten up on terminology here. For DataStage node is a single, logical, processing node. In particular, a node is not a network node name (such as occurs in the fastname property of a node definition).

Land it to a Data Set. That's what they're for.

Open in new tab/window would be nice.

Moderator: please move to QualityStage forum.