DSXchange

Your hashed file is externally pathed. Consider writing a quick function that utilizes the OPENPATH statement to open the hashed file, then a READ statement to read the appropriate row from the hashed file. Consider also changing the hashed file to a sequential file. I'm sure you are more comfortabl...

If you search for UVCONFIG on the forum, you'll see all of the various tuning values that people would consider changing for their appropriate issues. For a new user to the tool, this information can be invaluable, please spend a little time researching. It's well worth the time. Windoze or Unix rea...

In the command stage, you don't use DS BASIC syntax, so remove the colons. Simply use the #parameter# token wherever in the command syntax a parameter value is required.

You need to google "grid computing". It's a method where computers share their power, think of 50 PCs sitting on desktops around a company doing word processing and email all day. At night, all of the PC's become a larger virtual computer of 50 cpus working together to process data. Those 50 machine...

What exactly are you doing? Why are you trying to "register" the Oracle 8 plugin?

Pick 1 row of data from your primary input stream. Take your EXACT reference lookup SQL and fill in the WHERE clause cursor values and run that query in a SQL editor. Do you get the exact answer you need?

What do you mean by "entire data"? Row counts would be helpful at this point. If you have 1000 rows in the primary input stream, your multi-row reference lookup could generate N rows per input row, so do you mean that every input row is getting 2000 output rows generated? It would seem that your WHE...

Hard habit to break. Hash is the algorithm, hashed is the file.

Must flagellate myself later...my wife says I'm ruining her English...

Your statements are nearly indecipherable. The primary input stream will determine how many target rows will be written. The reference streams only effect the number of target rows if: 1. A constraint limits the output of the row from a transformer based on a reference lookup value. 2. Multi-row ref...

Multiplying values with a NULL causes an Abnormal Termination, so it behooves all developers to insure that NULL values never get put into an expression.

Also, before/after subroutine calls to non-existent routines causes problems.

Welcome aboard. You'll find lots of information in the Newsletter archive, and the most recent newsletter included information about hash files that should answer most of your questions. Please take advantage of the Search facility, 70000+ postings should cover many questions. It's always helpful to...

Stick to the basics and you'll be fine. I write a lot of scripts using MKS and they're extremely portable. The worst problem is dealing with Windoze filenames and such.

No but you can do the math in a reusable function.

Whatchoo talkin about?

Thanks Kenneth for the reply. You mean to say Oracle Enterprise LOAD option is the fastest as it falls under Direct Loading method. Is it faster than Oracle Bulk Load as well.? Yes, but remember it IS bulk loading using sqlldr. In the Oracle Enterprise Stage, i use UPSERT option with User-Defined U...