DSXchange

It's certainly possible, though you probably need a separate lookup for each level.

Why not use the MONTH.LAST transform?

Refer to parameters in Parameter Sets using "dot notation". Use values file by specifying the values file name as the "value" of the parameter set.

Job parameters are given their value when the job run request is submitted, not after the job is running.

Before job subroutine
Stage variable initialization
(For each row)
(For each output link)
Stage variable evaluation
Constraint
(If satisfied) Output column derivation

After job subroutine

What a piece of luck to have struck process ID 12345! The problem may not be with your configuration file, it's with the setting of the TMPDIR environment variable. What is the value of %TMPDIR%? Are the scratch disks identified in the configuration file local, or NFS mounted? Local disks for scratc...

srinivasudatastage wrote:what is diferrence between 8.0 and 8.5

0.5

I have a new 8.7 installation on Windows Server 2008 R2 INCLUDE=E:\IBM\SQLLIB\INCLUDE;E:\IBM\SQLLIB\LIB;C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\include;C:\Program Files\Microsoft SDKs\Windows\v7.0\Include LIB=C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\lib;E:\IBM\SQLLIB\LIB; ...

Two solutions. One is to leave the Parameter Set "value" as (as defined) throughout. The other, really useful if you want occasionally to use different values, is to make use of "values files" for the Parameter Set. In this case use the name of the values file instead of "(a...

Are you using special variable handling such as CRITICAL MISSING OK or are you using disagreement weight override?

CLEAR.FILE will cause you problems if jobs are still running, as it will wipe out the control records such as //SEQUENCE.NO and //JOB.STARTED.NO.

Search DSXchange for a routine that will purge records according to a date or number of runs.

Auto-purge will only happen if the job finishes successfully. That is, "Finished" or "Finished (see log)".

I think they're talking about the Filter stage, James.

nravikrishna wrote:to find max sal using remove duplicate stage

That's like asking how to join water pipes using a screwdriver. What ever happened to "the right tool for the right job"? Why using this particular stage type, whose function - I should not have to say - is NOT about finding maximum values.

Please tidy up your Code so that everything's aligned properly. Use the Preview button till you have it right, then Submit. Is there always five weeks worth of data? That is, five rows in the input stream? If so there's an easy solution using a Transformer stage to construct the wide record, and an ...

EVAL always needs double quotes, and particularly if the contained expression uses single quotes.
works fine for me. (Note that field #1 is always "" because CATEGORY always begins with "|".)