DSXchange

Hi, We have 100+ jobs in our project. Recently we discovered that we have used (unintentionally) Basic Transformers instead of Parallel Transformers in few of the jobs. We do not know which jobs are victim of this. As per my knowledge, we can check for the type of Transformer being used by generatin...

Hi, In my job, I am accessing a dataset for lookup purpose at five places. At all the Lookup, key columns are different. Dataset contains around 0.4 million records. Is it recommendable to access the same copy of dataset simultaneously while looking-up, as in my scenario? Secondly, as lookup dataset...

Thanks Ray!

Hi,

Can we use sparse lookup with DB2/UDB API stage?
If yes, where do we need to change the settings?
If no, is there any workaround?

Thanks in advance!

Another question arising in my mind:

I have a job which uses a lookup fileset for lookup. If I run 5 instances of the same job simultaneously, will those instances use the same lookup fileset fetched into the memory OR will each job bring its own copy of fileset into memory?

The most usual reason for this error is that you lack write permission on the client machine, where the XML file needs to be generated as part of compiling a job sequence. Ray, Can you please elaborate why does it generate the physical file as part of compilation? That too on client machine? Thanks!

Thanks Ray!

ArndW says:

The IBM website offers all of the UniVerse documentation free of charge in PDF format for you to download.

Can you please give us the URL from where we can download the mentioned PDF?

Thanks in advance!

On larger lookups the lookup fileset can be used immediately, other types of lookup need to be loaded into a temporary lookup fileset which is removed after the job finishes. Why does DS load other types of lookup into temporary lookup fileset? Can't it directly load the data into memory where it c...

Hi, I have few queries related to filesets: 1. How does a lookup fileset differ from fileset? 2. How does DS stores lookup fileset which differs from storing a dataset? 3. What if I use dataset in place of lookup fileset for lookup? 4. Any other significant difference between the two? Thanks in adva...

You can use CurrentDate() function.
To add n days to current date, use CurrentDate() + n
To subtract n days from current date, use CurrentDate() - n

This fuction is even listed in Functions> Date & Time in derivation field in Transformer.

Ray, please refer to my last reply on this thread. dsjob -run -param parameterfile.txt project job is wrong command as pointed out by Anupam. I am not sure if this format has been documented anywhere, but this is what we are using in many of our projects, and it's working absolutely fine. We are mai...

As mentioned by Ray, Filter is like WHERE clause in your SQL while Switch is analogous to Switch in 'C' language, where you set cases.
Switch supports atmost 128 output links while Filter supports any no. of output links (atleast in theory). Both the stages can have an optional Reject link.

Oh yess.. The command would remain dsjob -run -param name1=value1 -param name2=value2 project job Anupam is right that for each parameter used in the job we need to specify in -param argument, -param name1=value1, name2=value2, ... , namen=valuen Still we can have a file where we keep all the parame...

You can even store all your parameters in a flat file and pass this file to -param argument.

The format of the parameter file should be:
paramater1=value
parameter2=value
parameter3=value
..
..
And your command would become

dsjob -run -param parameterfile.txt project job