Oracle sys_guid() function in DataStage ??

Aquilis · Post by **Aquilis** » Mon Sep 22, 2014 9:01 am

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

chulett · Post by **chulett** » Mon Sep 22, 2014 3:07 pm

Not that I'm aware of. You'd either need to roll your own or just stick with the native functionality in your database.

ray.wurlod · Post by **ray.wurlod** » Mon Sep 22, 2014 4:08 pm

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.

prasson_ibm · Post by **prasson_ibm** » Wed Sep 24, 2014 12:12 am

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 · Post by **Aquilis** » Tue Sep 30, 2014 10:30 am

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.