calling oracle function

pavan31081980 · Post by **pavan31081980** » Wed Nov 04, 2009 3:24 am

Hi

How do i call a oracle function in datastage 8.1 version. I have a mod 11 function in oracle which i need to call in my job. please let me know how i can call a oracle function and with which stage i can call it? Thanks in advance.

Regards,
Pavan

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Nov 04, 2009 4:05 am

You can use Oracle Enterprise stage.

pavan31081980 · Post by **pavan31081980** » Wed Nov 04, 2009 4:10 am

[quote="Sainath.Srinivasan"]You can use Oracle Enterprise stage.[/quote]

Can you please let me know how i can do it using oracle enterprise stage?please give me brief steps to implement the same. Thanks

srinivas.g · Post by **srinivas.g** » Wed Nov 04, 2009 5:16 am

select function name(parameter) from dual

chulett · Post by **chulett** » Wed Nov 04, 2009 7:48 am

The same way you would in any other tool, you 'select' it as a field in a sql statement.

Sreenivasulu · Post by **Sreenivasulu** » Thu Nov 05, 2009 10:29 am

You can use ODBC stage as well.

Regards
Sreeni