DSXchange

Any idea?

Hi Mentors, i am trying to achieve below things, but couldn't get idea. seq_child---> multiinstace seq_main--> multinstance seq_child have series of multiinstance job which i have parametized as #invocation_id# either INTL or DOM i am calling child in main, now seq_main one instance need to be run w...

you can put resolve

Hi All, i was just wondering non recoverable option in DB2 bulk load option.. i see the explationation "True indicates that your load transaction is marked as non-recoverable. It will not be possible to recover your transaction with a subsequent roll forward action. The roll forward utility wil...

when you take export there is option include dependens item..
you just check it would import all parameters as well.....

check the enviorment in which you are reading it... since it partition it wont work on two different enviorment unless config file is same for both... i mean if you are reading dataset which created on 8-node config server to 4-node it won't work .... for that you should create new dataset on 4-node...

@vidyut.. a single cpu can have multiple logical nodes as well as.... @ravi yes you can split in to two nodes by defining config file as you described but as cpu is one it won't improve performance of your job.. also data would be splitted on two nodes as you mentioned one with 10 node1 and 20 on no...

you never said dupicate to be captured... there are many ways but one which i have tried ans tested sort the data using sort stage on key column which decide your duplicate.. then aggregate on same key. so you will have column value and count... now inner join input file with one the output from agg...

why not use RD rather than x'mer?
Is it interview question ??

probably your job were not in compiled when you have attached to sequencer.....
so when you restared it have complied that job automatically

Hi Craig.

i am expecting OP1: as shown in 1st post.

i will be modifying codes as per your input...
let see if it work

thanks.

Cheers!!!!
Devesh

0x20 is the value for APT_STRING_PADCHAR.

i have already tried with all space removing function...but its not resolving.

check your sql statement....
or post it here so we can give it thought!!!!

hey craig...

apology for being impatiance but i am stuck badly at this satge nearing to my delevery date...

i have used APT_STRING_PADCHAR .....
i have used by using selecting env variable so no chance of typo at anywhere...

Hi Kirti, Thanks for quick reply... Have you tried using trip function? Also did you check the filename in job 4 and 5. May be the file is getting overwritten? I believ you reffering to strip function , i have already used this strip are you reffering to strip function , i have already used this str...