DSXchange

Any statement that has THEN or ELSE (or ON ERROR or LOCKED) clauses can use "single-line format" or "multi-line format". Here is a formal statement of the syntax rule. If the keyword that introduces the clause (THEN, ELSE and so on) is the last word on the line on which it appears , then there must ...

Well, I would have given pretty much exactly the same answer! But my time zone (Thailand) meant that Ken beat me to it!

These may seem like silly suggestions, but have you tried:
(a) refreshing the view?
(b) closing and re-opening MetaStage?

Teej -> where can I have online class on Quality Stage. Where can I found some documentation on Quality Stage Your answers can be provided by your sales representative at Ascential. They provide both, and in fact, I'm sure that in hopes of making a sale, they would be happy to share both with you f...

I could be wrong, but both of these solutions seem to give only a character representation of the desired result, at least when written to a Sequential File stage. For example: oconv("9","MB") = "1001", not a true binary field, but rather an ASCII character field. (In hex it would be x31303031, I b...

The job itself can set an environment variable. So can an active stage. In the Transformer stage that drives the connection to DB2, set up ExecTCL as a before-stage subroutine (in the Stage Properties window), and put the an ENV command into the Input Value field. The ENV command to set an environme...

This looks like very inefficient code. As Ken said, Lp is being used as a dynamic array, which is simply a delimited string (though with reserved delimiter characters). In this code, Lp can end up after the first loop with anywhere between 0 and 120 elements. Without knowing what the incoming values...

Do you have a filter enabled? (If so, the word "Filtered" usually appears in the status bar.) Perhaps you're filtering out the current version. Remember that each import generates a new version.

From memory (and since MetaStage runs only on Windows), the Windows wildcard character ("*") should do the job for you. Then again, my memory has been known to be fallible.

I'd recommend you re-think that statement. Typically the final step in INTEGRITY processing is a pre-built procedure, Survivorship. You can't add your own operators to pre-built procedures. On the other hand, you can add pre-build procedures to your own user-defined procedures. But best practice is ...

It's not a very helpful error message, is it?
Just a thought, since you're on AIX, it might be worth trying to set LD_LIBRARY_PATH so that it, too, includes $DB2_HOME/lib.
And to make sure that these environment variables are set in the dsenv file, so that every DataStage process sets them.

And what Teej quoted are minima. More is better. Just in case you're new to PX, "processing node" can mean a CPU or set of CPUs in an SMP environment, or a CPU or set of CPUs on the one host in an MPP environment.

hi, Want to know some basics What is Quality Stage? What is the use of Quality Stage? Doest it come along with Datastage or need to buy seperately? How it is related to Datastage? Thanks in advance Girish Oak Among a series of acquisitions of technology over the last couple of years, Ascential acqu...

Hi, I have some different kind of requirement probably anyone of you, may or may not have face this. My requirement is as follows. I have a record that has three columns for address say addressline1,2 and 3. Any of these line1,2,3 may contain zip code city state and country value. Unfortunately the...

The ABSOLUTELY EASIEST way is to choose File > Print, then check the Print to File option.