Page 1 of 1
Oracle sys_guid() function in DataStage ??
Posted: Mon Sep 22, 2014 9:01 am
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
Posted: Mon Sep 22, 2014 3:07 pm
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.
Posted: Mon Sep 22, 2014 4:08 pm
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.
Posted: Wed Sep 24, 2014 12:12 am
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.
Posted: Tue Sep 30, 2014 10:30 am
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.