accesssing a hash file in a Basic routine

supernova2005 · Post by **supernova2005** » Mon Jan 24, 2005 10:20 am

Hi everyone,

I need to write a Datastage basic routine to lookup a hash file and return the result.

Does anyone know how I can do it?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Jan 24, 2005 10:22 am

You can refer to 'KeyMgtGetNextValue' under Routines -> SDK

kcbland · Post by **kcbland** » Mon Jan 24, 2005 10:33 am

Better yet, use the hash file lookup function under the SDK folder:

Code: Select all

Routines
---->SDK
--------->  UtilityHashLookup

ray.wurlod · Post by **ray.wurlod** » Mon Jan 24, 2005 3:42 pm

Welcome aboard! :D

I need to write a Datastage basic routine to lookup a hash file and return the result.

Why? This is exactly what the Hashed File stage does! Why do you want to re-write DataStage functionality in code (to be used within DataStage!), which you then need to maintain?