surrogate key for a hash table

bigpoppa · Post by **bigpoppa** » Fri May 16, 2003 12:12 pm

DS 6.0r2
Server : Sun Solaris
Client : XP

I'm inserting rows into a hash table. The table has a surrogate key. Is there an easy way to implement the surrogate key? Perhaps using something like a Serial column for the key, etc?

Thanks,
bp

chulett · Post by **chulett** » Fri May 16, 2003 3:43 pm

Can you not take advantage of the 'GetNextValue' routines in the sdk?

Specifically, under Routines/sdk/KeyMgt:

KeyMgtGetNextValue (use when concurrency isn't an issue)
KeyMgtGetNextValueConcurrent (for when it is)

-craig

ray.wurlod · Post by **ray.wurlod** » Fri May 16, 2003 5:36 pm

If you create the hashed file using a CREATE TABLE statement (which you will have to do manually) there is a keyword (from memory it is NEXT.AVAILABLE) that you can use in the PRIMARY KEY clause. It's the weekend here, and I don't have my DataStage machine booted, so can't check. I will verify the actual syntax next time I have it available. But the short answer is yes.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518