DSXchange

So we can blame Microsoft?

You can do this in DataStage, by using user-defined (rather than DataStage-generated) SQL. Just make sure that the column names and expressions in your SELECT clause align with the column definitions on the output link of the stage. It might be an idea to CAST the result as NCHAR or NVARCHAR2 data t...

The target must be string of some kind. I took that as a given when the original poster asked about inserting commas, which are not numeric characters.

... or $DSHOME/bin/dsjob -lprojects will do the same without needing dssh.

The key word is "should". QualityStage will work without accurate match frequencies, but the probabilities that it uses will not be as accurate. You can certainly generate a standard set of frequencies, but they will likely bear little relationship to reality.

On a web service call, you would quite likely use a two-file match. Yes, you would need to generate frequencies for the tiny number of rows arriving from the web client, but that will not take very long. The match frequencies for your "values on file" set can be pre-calculated at an interv...

When you log in to DataStage, you do so from the client tier. You specify the hostname of the services tier to authenticate your credentials. You specify the hostname of the engine tier when specifying the project to which to connect. If these three hostnames are all different, then the tiers are on...

I would use a UNIX command You would. :lol: But there are perfectly adequate DataStage BASIC expressions that can be used directly when assigning parameter values in a job activity (or storing them in user variables) without the need to create additional shells. For example @DATE - 1 returns yester...

Thank you for that useful contribution.

Hopefully future searchers will happen upon this post.

The following DataStage BASIC routine shows one algorithm that can easily be used to convert a string comprised entirely of numeric characters into a "lakh format" string. You could perhaps adapt it into C++ for use in a Build stage or a parallel Routine. FUNCTION LakhFormat(aNumber) If Un...

There is nothing available out of the box for parallel jobs to display numeric data as strings using lakh format. You will need to use either a BASIC Transformer stage, or a server shared container containing a Transformer stage, or indeed a server job containing a Transformer stage, to effect this ...

Note, in particular, that sequence jobs are NOT parallel jobs. They execute using the server engine. You do NOT need parallel job functions in sequence jobs.

You really need someone who understands the startup process of AIX.

The link that gets created in /etc/rc.d folders has the numeric component to the name, reflecting execution order. The prototype in sample directory does not have the numeric component in its name.

PaulVL wrote:Side note:

1 post will do, not 5.

Further side note: private messages seeking assistance are assumed to be seeking that assistance on a commercial basis.

You don't need your own script. The software that is installed (Information Server generally, the engine tier in particular) includes a script called ds999.rc (in the sample subdirectory). Links to this are created in /etc/rc.d, /etc/rc2.d, etc., so that DataStage restarts correctly when AIX is rebo...