Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
Aquilis
- Participant
- Posts: 204
- Joined: Thu Apr 05, 2007 4:54 am
- Location: Bangalore
-
Contact:
Post
by Aquilis »
Hi,
What is the quivalent function in DataStage to generate sys_guid() value for each row as surrogate key.
Oracle has - sys_guid() function, any equivalent function in DataStage ?
select sys_guid() from dual
Aquilis
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
Not that I'm aware of. You'd either need to roll your own or just stick with the native functionality in your database.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
DataStage does not have any capability to generate GUID values.
There are several strategies you could use to have DataStage query the database for a GUID value.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
prasson_ibm
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Post
by prasson_ibm »
Hi,
I have used java code to generate GUID in my project, and it is working impressivly.
Let me know if you need a code.
-
Aquilis
- Participant
- Posts: 204
- Joined: Thu Apr 05, 2007 4:54 am
- Location: Bangalore
-
Contact:
Post
by Aquilis »
I use MS-SQL Server as Source System and Oracle as Target System.
Our customer follows some annoying coding standards and one of them is not to use User-Defined queries at oracle side while INSERT/UPDATE.
So I used NEW_GUID() in SQL Server while selection and populating the Oracle database.
Many thanks for all the Suggestions.
Aquilis