DSXchange

In our project, we will force the guy to restructure the file before passing to the BuildOp (or Transformer). For example : file1columnsare: A B C D E F -> no change file2columnsare: A B D F C -> A B C D *E F file3columnsare: A B C D F -> A B C D *E F As you know, the order does not matter to the ac...

I am also new to BuildOp. I have located the output of BuildOp in the project directory ... under buildop For every BuildOp defined, five members are created ... testing.C testing.h testing.o testing.opd testing.opd.sh You may find your code / logic in the ".C" file. Maybe you can get some...

Have you turn off the auto write / read option in the output / input ? You may have to define the way of reading / writing record by yourself. For example, In the pre-loop logic: init the key init the temp variable In the per-loop logic : check the key if key break write record read record Let's hav...

Where can I get more information about JobMonApp?

The data that loading into table XYZ have not particular, unless, you perform sorting explicitly. It is because DS will create data partition for the inputs, example : Records in Table A B C D Records during intermediate processing (with natural partitioning) Partition 1 Partition 2 A B C D The sequ...

Can you give more details about your project background? As I know, the RTI component require seperate license fee .... which may costs you a lot .. why don't you try to accumulate the data with a simple program .. and use process later in a batch ... or you really need a near real time solution. le...

Have you try to enable multiple instance?

I have the same problem before. From my experience, the problem is much simple if there are only a few alternative values for Fld1. Let's say Fld2 can be '01','02','03','04' only. You can use following flow : Input -> Sort -> Transformer -> Output Fld1 Fld2 Fld1 Fld2a Fld2b Fld2c Fld2d ----- ----- -...

Finally, I got the answer.... 1) Put a transfomer about the join stage 2) Create stage variable to work out if the key is null or not. Refer to the sample code shown below. 3) Create output link from transformer and setup the constraint accordingly to the stage variable defined. Sample code used in ...

I'm not quite sure about Iconv function, is it for Sequential Stage or PX ?
It is available in Transformer in a PX job?

I got some hint from my fx, for example

Convert(Chr(0),"0000",AAA)

Any idea about this function?

I have define a fields to be char(2), and use it to store data generated from mainframe.

The data looks like this (in hex representation) : \x0001

Is it possible to extract the content '0001' to another string?

Any hint?

I just find something similar. Use shell to kick off the job, wait for the return status. If status = something, then reset the job ... A sample code was shown below for your comments. runinfo=`dsjob -run jobstatus $PROJECT $JOB 2>&1` dsjobStatus=$? if dsjobStatus ?? dsjob -run -mode RESET $PROJ...

It sounds GREAT !!

Would you please post the final version DS code and shell wrapper? Thanks a lot !!!!!

I think you may find the checkpoint-restart feature in 7.1 or later version, e.g. 7.5. However, from my own experience, the tool does not seems better than do it yourself.

Anyway, goto your supporting consultant and ask for an evaluation.

Thanks to santhu. You stated that there is no possible to capture the unmatch record from JOIN. However, when I check the output form an full outer join, the recrods are there !!! I just wonder how to get it out ..... Any tips ? The output looks like this : L Key R Key L Value R Value A A V1 V9 A (?...