I have a need to generate UUIDs in DataStage 7.x to be used as the key column for new rows in a target Oracle database. Has anyone worked with UUIDs before? The Web has various information on UUIDs and GUIDs, but nothing specific to my AIX 5.1 environment. I can generate a GUID using the SYS_GUID() function in Oracle, but I would rather use a shell script wrapped in a routine to call a Unix function without having to make the connection to Oracle for each iteration. Any help would be appreciated!
Thanks.
Alan
Generating UUIDs or GUIDs in DataStage
Moderators: chulett, rschirm, roy
Kim,
UUID is a Universal Unique IDentifier. You can do a Google search and browse the topics. The target database I'm loading uses UUIDs as surrogate keys. The Siebel application generates its own UUIDs when loading data via XML. I have to emulate the process for the initial (history) load of the data and for any new transactions that come in. You might think of UUIDs as a guaranteed unique surrogate keys based on current time/date, MAC address, and some other fuzzy logic.
Have fun back home,
Alan
UUID is a Universal Unique IDentifier. You can do a Google search and browse the topics. The target database I'm loading uses UUIDs as surrogate keys. The Siebel application generates its own UUIDs when loading data via XML. I have to emulate the process for the initial (history) load of the data and for any new transactions that come in. You might think of UUIDs as a guaranteed unique surrogate keys based on current time/date, MAC address, and some other fuzzy logic.
Have fun back home,
Alan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks, Ray. I read through what you wrote a few months ago, but I couldn't really apply it to my project. I can generate a UUID via Oracle, but I'd rather not make the database call. I'd like to execute a Unix command, but the ones I found on the Web are not what's available to me right now on my client's server. I figured there may be a C program or Unix script out there that someone has used before that I could take advantage of. Barring that, I'm probably just going to use Oracle to generate the UUIDs (GUIDs) for me.
Ray, your responses are always welcomed and informative, and those of us that have been doing this kind of work for a long time really appreciate the time and effort you exert in responding to questions, no matter how trivial or complex. I hope to be able to present a solution to my problem to the forum for future reference.
Thanks,
Alan
Ray, your responses are always welcomed and informative, and those of us that have been doing this kind of work for a long time really appreciate the time and effort you exert in responding to questions, no matter how trivial or complex. I hope to be able to present a solution to my problem to the forum for future reference.
Thanks,
Alan