stored procedure - result set

fmartinsferreira · Post by **fmartinsferreira** » Thu Jun 29, 2006 1:42 pm

Hi!

My source is SQL Server!

I need to work with a result set from a SQL Server's stored procedure in DataStage and after input the data into a Oracle.

Is there any stage that work with a stored procedure result set?

In the version 7.5 there is a "stored procedure stage" that work with Oracle, DB2 and Sybase but don't work with SQL Server.

By internal rules I can't read the SQL Server directly.

Regards

Fernando

kcbland · Post by **kcbland** » Thu Jun 29, 2006 2:08 pm

ODBC stage, toggle SQL choice to stored procedure.

fmartinsferreira · Post by **fmartinsferreira** » Thu Jun 29, 2006 2:20 pm

Thanks!

ray.wurlod · Post by **ray.wurlod** » Thu Jun 29, 2006 3:48 pm

fmartinsferreira wrote:My source is SQL Server!

Why are you surprised?

fmartinsferreira · Post by **fmartinsferreira** » Tue Jul 04, 2006 8:07 am

ray.wurlod wrote: Why are you surprised? ...

Because it is the first time that I have SQL Server as a source.

Fernando

DSXchange