DSXchange

Suiteadmin is a role in Information Server - it is unrelated to DataStage. Perhaps the Information Server login/security service has failed for some reason. Did anyone change anything?

Perhaps the word "either" means that you must have one but must not have both. But that seems strange to me. Experiment further. Let us know.

"PART" is non-numeric. Attempting to add will generate "non-numeric where numeric required, zero used" error. Concatenate it is.

Comparison operators such as "=" must make decisions about whether the operands are numeric or not, so as to perform the correct type of comparison (string or numeric). The third argument of Compare() - the "justification" argument - allows this to be forced. The following code ought also to work. I...

Presumably you are using triggers based upon the command output (activity variable $CommandOutput) to make the decision about whether to run Job1 or Job2?

Use the DataStage API. Either in BASIC or C.

Not in the server forum! Server jobs don't have a Modify stage. Or two.

7.5.1.A or 8x ?

Has the ORAOCI9 stage been properly installed and registered?

Can you access Oracle using ODBC from DataStage?

I guess, even before that, is to ask the question whether DB2 client software is installed on your DataStage server machine. It does need to be installed.

I am assuming you are using a Lookup stage. Simply change the Lookup Failed rule to "Continue" and make sure that every output column derived from the reference input link is defined to be Nullable and/or has a default value set. The former, if you explicitly want NULL.

PATH is the search list for commands. What you really need to check is the search list for shared libraries; depending on which UNIX you are using this is an environment variable called LD_LIBRARY_PATH, LIBPATH or SHLIB_PATH.

The logic in the routine should work. If NewValue = LastValue Then Ans = 1 End Else Ans = 0 LastValue = NewValue End Just for interest, though, take a copy of the routine and replace the above logic with the following. If Compare(LastValue, NewValue, "L") = 0 Then Ans = 1 End Else ...

I observe that the timeouts appear to occur less frequently if there is a final empty line (that is, if the insertion point is moved to the beginning of a new line, rather than being left at the end of the final line, by pressing Enter).

Of course, this may be just a coincidence.

Spend some time learning about dynamic arrays in DataStage BASIC programming. All multi-line log entries are dynamic arrays. In particular, the dynamic array delimiter characters, such as 0xFD, are not junk. 0xFD is (contrary to what Arnd assumed) a "value mark" character, which is represented by th...

Passing through yet another airport on the weekend I saw an ad for Bose (audio equipment) suggesting that you would get surprising performance from whatever it was they were selling. Is this the same "performance" you expect to get in an ETL environment? I don't think so. Arnd neglected to mention t...