DSXchange

Don't you also have to add a new "parallel routine" to the DataStage repository, to allow DataStage to check the number and type of arguments, and so on?

This is actually a reference to the existence of the function.

Welcome aboard. :D While you CAN assign weight to every field in the Match stage, you don't want to. Let QualityStage calculate the weights based on the frequency distributions in the data, which you may have reported upon in an investigation. There are agreement and disagreement weights calculated....

Welcome aboard. :D

If you draw a reject output link from the DB2/UDB Enterprise stage, the columns from the input link will automatically appear. An additional column, called sqlcode, will also appear. This is the mechanism for capturing the error code generated by DB2.

The DLL in question must be an OLE server, so as to expose ActiveX objects. Is yours?

There are no duplicates in a hashed file. The hashed file has a primary key. By definition, the key to a hashed file - the Primary Key - is unique. A primary key is unique in every database of which I am aware.

What are you trying to accomplish?

A Hashed File stage accesses a hashed file, which must have a primary key. Spend some time researching/learning. A Hashed File stage can NOT be used to access a text file. You must use a Sequential File stage, Complex Flat File stage or Merge stage for that. Please document (post) your job logic (an...

From a before-job or after-job subroutine by using ExecSH or ExecSHSilent as the routine. From an Execute Command activity in a job sequence. Depending upon what the remote shell has to do, from a Wrapped stage in a parallel job, or maybe an External Source, External Target or External Filter stage....

Have you ever CREATED the hashed file? Your job is quite clearly NOT completing successfully if you are getting this error.

You could try using uvregen. Stop DataStage before doing this.


Otherwise, if that does not work, you will need to re-install the server component.

The compiler must be separately purchased, typically from your operating system vendor.

Yes, subject to all the caveats associated with rsh from wherever it's invoked.

You can do it in DataStage BASIC. This routine is one of the examples from my Programming in DataStage BASIC class. You can find more details on my web site. The function handles whole numbers between 1 and 999999999999. It is used to show how to use the GoSub statement. Error handling (in particula...

I would be more than happy to pay for it!! [/b] You haven't seen my fees! Learning where to look is half the battle. Reading manuals and readme files is how I keep up to date. One day I'll retire, or even take a vacation, and then you'll all have to stand on your own just that little bit more. I'm ...

You can set up a job parameter with the start value, and simply add the value if @OUTROWNUM to it. This is an alternative to using the SDK routines.

Search the forum; there are detailed instructions on initializing a sequence in SDKSequences.

When you mark a column as Key in this context, it means that it is a "join key" rather than a primary key - that is, the column that will appear in the WHERE clause in any generated SQL SELECT statement.