DSXchange

Hi Ray
Your solution is as always interesting but i can't find the start/end loop activity in the designer.

Hi, Here is my own "seek a parameter" routine. Arg1 is the name of the parameter we want. * Open The File OpenSeq ParamFile to paramtemp Else Ans = "Not Found ":ParamFile * Read the File loop while ReadSeq param from paramtemp varParameter = upcase(field(param,'=',1)) varName = u...

Hi,
I don't understand the randomly thing.
For the rest you can read your file,seek for your parameter and use the DSSetParam function.

Hi,

I tried to find the code of the jobreport routine but my search failed.
I'm afraid that we lose it.

Hi

I tried to contact Tony Curcio by email but the one i have it's not valid anymore.
I'm looking for the code of the jobreport routine.

Thank you.


Do i have to do a new post ?

Hi

Thank you for the post and for the zip.
Sorry about the message.

I think that you can't do that without lose or separate the Skey. I think a transformer with an aggregator will do what you want but again a key is a key if it's unique. Agg1(Sum(amount) on Skey,EID,Aeskey) ---> Transformer (Skey,NewAmount) ---> Agg2 (Max(amount) on Skey) ---> hash_file (Key?) I don...

Hi I don't understand your last post. If you sum your amount on Skey you will have only one row in the aggregator ouput. Skey Amount 1 100 2 200 1 100 2 200 3 300 with this data the result will be Skey NewAmount 1 200 2 400 3 300 And now the hash_file with don't override any records.

Hi

I would say your key is not a key because it's not unique.
What are the traitements include in your next job ?
How is working your lookup ?
Maybe you can add a column which will become the hash_file key.

Hope This Help.

Hi,

You must have a key in a hash_file stage but maybe you don't need this stage.

You can use the ouput of the sort stage directly.

FILE --> SORT ---> TRANSFORMER

Hope This Help

Hi
Do you have keys in your hash files ?
Is so maybe some records are override.

Hope this help

Hi I am agree with changming except for the loop because we are in windows. But you can write a job control who call your job x times with the value to proceed in parameter. You should include this parameter in all the stage to name the file. * Setup SplitJOB, run it, wait for it to finish, and test...

Hi

With a transformer you can assign what you want to the last record.

I have all my answers.
Thank you all

I will do that.
Do you do the same in the jobcontrol or do you use dsjobname ?
Thank you all.