DSXchange

Posted: **Wed Sep 06, 2006 7:16 pm**

If you are hardcoding everything including Hashed file name then you should include quotes for everything.

UtilityHashLookup("XXX", "KeyValue", "1")

In between, how is your hashed file created? Pathed or in the Project? If pathed, did you create a pointer in VOC using SETFILE command?

Posted: **Wed Sep 06, 2006 10:36 pm**

You won't need a RoutineActivityStage in between your Jobs. Code:
JobActivity1->>JobActivity2

In your JobActivityStage2, for the last parameter, rightclick and choose DSTransform>>>sdk>>>Utility>>>UtilityHashLookUp and then pass the values in here.

Kris, I am on 7.5 and I cannot right click and do this. I think you are on 7.5.1A therefore you can get this formula. I need to do a routine activity. 7.1 could not do this at all. No matter how he gets it then this routine needs to be called.

Posted: **Wed Sep 06, 2006 10:38 pm**

By the way you will not add much to a project directory if you leave this hashed file in the project. It only has one record. Not a problem.

Posted: **Wed Sep 06, 2006 10:58 pm**

kduke wrote: Kris, I am on 7.5 and I cannot right click and do this. I think you are on 7.5.1A therefore you can get this formula. I need to do a routine activity. 7.1 could not do this at all. No matter how he gets it then this routine needs to be called.

I was on 7.5 Windows at my previous client site and I implemented this successfully. I am not sure why it is not working for you.

The parameter needs to be of type string or integer or anything except filename or List. It worked for me.

Posted: **Thu Sep 07, 2006 7:55 am**

Maybe it is the XP patch that takes it away.

Posted: **Thu Sep 07, 2006 9:11 pm**

Where can I read about these routines? I can't find UtilityHashLookup anywhere in the documentation.

Posted: **Thu Sep 07, 2006 10:00 pm**

Not sure if these are documented but they should be in a folder called sdk\Utility. The source code is even included for most of these routines. Edit them and learn how to write routines. Great learning tool.

DSXchange

Is it possible to take the output of a select into variable