DSXchange

Create a key-only table called WINNERS and copy keys into there when they win. Apply your random selection to a DIFFERENCE set of the two tables (those in CUSTOMER but not in WINNERS).

I've been asked to provide a reference to where the different line colors that can appear in a data lineage report are documented. But I can't find one! So I'm hoping to engage the help of additional pairs of eyes here. Yes, I am aware that hovering the mouse pointer over the link will display infor...

Did you actually try it? It's not a documented argument.

It's unusual to create delimiters in the Transformer stage. What is the target stage for this job? Can it create the delimiters?

There can only be one record with the key value stored in variable ID. That's the whole point of a hashed file - the key value is processed through the hashing algorithm to return the address of the page on which the record is located (no need for indexes or table scans - very fast). NDC.REC is a dy...

You missed the BUILD.INDEX command to populate the index.

Did the email actually get sent? Even though you left the SMTP Server field empty in a Notification Activity, every unix machine should be able to act as a mail server. In that case, simply ignore/demote this message. Or provide the UNIX host name (probably from an environment variable job parameter...

You get the compiler from Hewlett-Packard, possibly through your official support provider. If your current version of the compiler is licensed, then you may be entitled to a free upgrade. But this compiler is NOT freeware.

A Routine activity is one of the components you can add to a sequence job. It executes a routine that is written in DataStage BASIC. While you could perform data type conversion in such an activity it would be pointless to expect to try to do so, because sequence jobs do not process any data - they ...

You may need a second option on the Char() function to specify these characters correctly. It asserts whether or not the most significant bit is on.
For example:

You may be able to download the patch from Fix Central by searching for the patch number, but there are no promises. You are on a really, really, old version.

It might make a difference if you did not copy the index(es) for the hashed file. These are stored in a separate directory, called I_NdcKeyLookup. Trying to run SELECTINDEX through DSExecute will always fail, because (as noted) SELECTINDEX is not a command (not in VOC); it is a part of the programmi...

You must compile the job as multi-instance capable (a check box in the job properties page). As you start each instance you give a different invocation ID. This is the approved, and only, mechanism for running clones of the same job at the same time. As you note, the file name will need to be passed...

SELECTINDEX is a keyword in the BASIC language; it will not be in the VOC file.

What error is generated when routine containing the statement is executed?

You ARE converting to a string, because a text file does not have data types - it only has text (string).

Actually, it's the export operator that is performing the conversion.