DSXchange

The best solution by far is to standardize the names using QualityStage. Read the online help for the Field() function. It will solve your need. Do you also need to handle "John Smith" (no middle initial) and "John G W Smith" (more than one)? Turns out there's a "one solution fits all" set of expres...

Learn to write the job control code, or hire someone with the skill. It's not a big ask. The main design specification will be how the list of table names is to be delivered.

The capturekkkkkkaa files are generated by the CAPTURING clause of an EXECUTE statement in BASIC. They "should" be deleted automatically. They are safe to delete once the job that created them is no longer running. On UNIX systems the kkkkkk is normally the process ID of the process that created the...

Click on Help.
Then click on the check box.
It should open a brief description of what's meant.
Then post that back here, so we can all know.

The ability to use job parameters in the Notification Activity was introduced in version 7.5. So, Christina, you will need either to upgrade or to create a script as Craig suggested. Search the forum, there's probably one already there.

Sparse lookup or normal lookup?

You should not have a space ahead of the seconds/milliseconds separator, but you have specified " ." (space dot).

Thanks for sharing that.

What do you think it means in terms of your job design?

It's nothing to do with languages; it's to do with encodings of characters. For example, there are at least two different ways to encode Korean characters, and at least fourteen in common use in Japan. And that's without counting the Microsoft variants! The "advantage", as you put it, is the ability...

No.

A bus error occurs on the backplane of the machine; that is, there's a problem somewhere with the hardware. Get your UNIX system admin involved.

Try installing to a different location.

Unless some very specific conditions apply, including that your sequential file is in fixed width format, it will not be processed on more than one node (that is, sequentially). Therefore, whether you follow the Sequential File stage with a Filter stage, a Transformer stage or some other stage kind,...

Visit Unicode Consortium web site to learn all about Unicode.
When NLS is enabled, DataStage uses an encoding of Unicode code points to store mapped characters from any data set, for example in hashed files and during processing.

Before you experiment with various functions (though Field() looks promising), why not document the required algorithm: that is, what do the data look like now, what do they need to look like, and what has to be done (in English) to get there? This is called a "business rule" and comes under the hea...

I'd be happy to bid for the work to rebuild his project!

I did try to address that in my reply, adding LIST to check and TYPE = "F" as an additional constraint on the SELECT. If you haven't destroyed the verbs you can always rebuild your VOC file (UPDATE.ACCOUNT and CLEAN.ACCOUNT). 'twas a valid question, even though one wonders whether the poster has tho...