DSXchange

For starters, delete the duplicate post before anyone responds to it.

How are you initially populating the lookup table?

What is "ar lookup"?

Can you load a local structure, such as a Lookup File Set, with the data from the reference table?
If not, why not?

The actual syntax will depend on which shell you are scripting for. Typically there's a statement that marks the end of the IF block. if [ $prj -eq 'dev' ] $path=/dev/pathname else $path=/tst/pathname fi Beware of using shell variable names that might be confused with environment variable names such...

How long is a piece of string? Seriously yours is not a question that can be answered without knowing the results of resource monitoring on your machine. If you don't use a Sort stage or a link sort but a sort is required, then a tsort operator will be inserted when the score is composed. So you end...

Obviously no explanation is required; thread is marked as Resolved.
Perhaps DSXchange's Learning Center - where you can take a Server to Parallel Transition Lab (class) - is for you.

U has not logged in for a couple of months.

Tough.

Anything you want to do with an input column in the Transformer (or Modify) stage you need explicitly to name that column in the stage input link.

Pass the value of the environment variable as a command line argument when invoking the script, and pick it up within the script as a shell variable that reads the command line, for example $1.

What happens if you use bin/dssh rather than bin/uv ?

Do you pre-execute the dsenv script?

DEFFUN declaration in A to tell A that B is a function name.

Welcome aboard. Rows/sec is not a good metric of performance. Rows/sec changes over the life of the job, particularly if you are using write caching and Hashed File stage to write to the UniVerse table. Yes, it is possible to tune UniVerse tables, but it's a non-trivial topic; you really should atte...

The order of components in data_date is (I am assuming) month, day, year so the second argument to Iconv() needs to specify this. Oconv(Iconv(InLink.data_date, "DMDY"), "D-YMD[4,2,2]") Substring fails because you can have one-digit or two-digit days and months. Yo...

Moderator: please move to Profiling forum

AuditStage is a profiling tool. TX is the WebSphere Transformation Extender.

How do you know that "8" means 2008 and not 1998?

Does "0" mean 1990, 2000 or 2010? What will "0" mean in 2010 or 2011?

Now is the time to persecute whoever is providing these data.

There are routines/transforms in the SDK that you can use. Why re-invent the wheel? Ultimately, though, you need to re-organize the components of the date into yyyy-mm-dd format (guaranteeing 4, 2 and 2 digits) then add a time component. (Actually, I believe SQL Server is happy enough without the ti...