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
surrogate key for a hash table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518