DSXchange

So whoever "wrote" that routine stole the code from UtilityHashLookup. Test for that particular value. If YEAR = "**RECORD NOT FOUND**" Then Call DSLogFatal("HashTableLookup Failed for YEAR: Batch::LoadETLFinLineMonth", "JobControl") End The Abort statement is r...

It means you've been reading too much Dickens, Uriah, and that you're not prepared to Search for answers.

Incidentally, when you search, make sure you spell "heap" correctly.

If you wish. It's a viable alternative.

Read my complete post. Oh. You haven't purchased your premium membership yet? Better do so, then, or have your employer do so. Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are defrayed. By taking premium membership you are not only getting the benefits ther...

Since HashTableLookup() was written locally at your site, it is impossible for us to comment. We have no information about how this routine behaves when the supplied key is not found. You could, as an alternative, use the SDK routine called UtilityHashLookup, or you could write your own Open and Rea...

Rank is a display function. Of course you could do it. But your output is wrong. It should be:
100 1
100 1
100 1
90 4
90 4
80 6
80 6

You can read about tied ranks in any nonparametric statistics textbook.

It is not possible.

There are already three different ways to sort in DataStage parallel jobs; there is no good reason not to use one of those.

And there's no reason why you shouldn't.

Search DSXchange for "vertical pivot" and adapt the techniques shown (which generate a separate column per input row).

$DSHOME contains a pathname if it is set. You couldn't execute it anyway.

Take some time to learn a basic subset of operating system commands and how the shell works, particularly shell and environment variables and pipeline and redirection operators.

Do you have any particular definition in mind of what "performance" means in an ETL context? There are probably many other possibilities, but if I suggest some of them you will reject them (for example bigger hardware, more nodes - though you are not processing a large amount of data really). Every ...

Answer that yourself by experimentation. Some metadata matches are insignificant, some are very significant (especially when, for example, one side is a numeric data type and the other side is a non-numeric data type). Prevention is always better than cure. Make sure that your metadata never mismatc...

Step 1. Be aware of your responsibilities as Admin, one of which is to know when it is safe to unlock jobs and when it is not safe to do so. Step 2. Ascertain who is holding the lock on the job. Get in contact with them and have them release (close) the job gracefully. If they can not be contacted a...

You do. It's called putting four entries into the scheduler interface with the times six hours apart and, perhaps, setting "every day".

I did. A very complete solution. Please purchase a premium memberhip that will allow you to read it, or have your employer purchase it. Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are defrayed. By taking premium membership you are not only getting the bene...