DSXchange

Thanks again for your help with the UtilityHashLookup. This is my company's first project with DataStage so I didn't really have an opportunity to join (much) sooner. Only 3 days I knew that blank defaulted to the current project, but I thought I'd be sure and obvious by typing in the current projec...

The key code values in the hash file are in all caps as are the arguments I am entering. No match is found even if I "view data", copy and then paste into my routine. I can't see any extra characters anywhere. I also tried calling the UtilityHashLookup directory in a transformer stage (instead of cr...

Thank you for your response.

I get the same "**RECORD NOT FOUND**" regardless of what I pass in the 3rd argument. 1, 2, A, blank, it doesn't seem to matter.

I do get a switch from "RECORD" not found to "TABLE" not found if I passed the wrong hash file name.

`` Emily

Hello, I am having trouble with my UtilityHashLookup routine. The code I have is DEFFUN UtilityHashLookup(A1,A2,A3) Calling "DSX.UTILITYHASHLOOKUP" TA1 = TRIM(A1) TA2 = TRIM(A2) TA3 = TRIM(A3) Ans = UtilityHashLookup(TA1,TA2,TA3) to A1, I pas the name of my account path saved hash file to A2, the ke...