DSXchange

In version 9.1 or maybe the following release Director functionality (submit/stop/reset) are available in the Operations Console. Though you still need an appropriate role to use them.

... only if the fields you're comparing in the stage variables have the same value on the same partition. Hence the need for correct partitioning.

Probably because Decimal precedes Numeric in an alphabetical list of data types.

Read all the input fields as Char data type. Replace the Copy stage with a Modify stage and apply string_trim() function to each field that you need trimmed.

Since you're on Windows, the installer may have gotten far enough along to publish uninstall information, in which case you can use Add/Remove programs from Control Panel.

Welcome aboard. Visit Kim Duke's website and download ETLstats, which can collect every link row count in your jobs and load them into, for example, a database from which you can report. It does quite a few other things as well, and it's free. "Success" is sometimes an elusive term; for ex...

You have four outputs and a reject link. None of these is an Otherwise/Log. Create another output link and, in its constraint, do not create an expression but merely check the Otherwise/Log check box. Make sure that this output link executes last.

You don't have an Otherwise/Log output, which you will need.

Read my earlier post again.

Index() needs three arguments - if it's any consolation, James missed this also. The third argument is the occurrence number you're searching for - this is almost always 1. But the function does, for example, allow you to look for the nth occurrence of the search substring.

Otherwise/Log output link catches any row that has not already been processed. You need to make sure that the Otherwise/Log output link is the last one executed (do this using the Link Execution Order tool). Reject link only captures input rows that cause an exception, such as an attempt to divide b...

If there is a length prefix, then it will be declared in the COBOL FD and, yes, if it exists DataStage can read it. However you may have to design in the "understanding" part, perhaps by specifying {prefix} in the record schema.

ANSI standard SQL does not have a data type called NUMBER. Indeed, as far as I am aware, nor does any database apart from Oracle. Oracle is... different. In DataStage, the data types DECIMAL and NUMERIC are considered to be the same. There are only a couple of databases in which the nuances make the...

Arnd's approach is totally valid.

This is a server job, so data type conversion will be automatic.

Another solution is DIGITS(InLink.TheString) + 0 (performing any arithmetic removes leading zeroes).

If you're wanting to do all this in the database, you don't need to involve DataStage at all.

If you want to do the ETL using DataStage, prefer Connectors to using stored procedures.

LDAP is merely a protocol for invoking something else, such as Tivoli or Active Directory. It's in those other environments where one sets up all the user IDs, even "service accounts" as they're usually called. On the Global Security page of the Integrated Console for WAS, what is the &quo...