Callingstor edprocedure in the datastage

cnu · Post by **cnu** » Fri Jul 18, 2008 9:00 pm

Hi:

I am trying to call the storedprocedure from the datastage to load the data into sqlserver target.Please let me know where can i call storeprocedure.

Thanks in advance
cnu

ETLJOB · Post by **ETLJOB** » Fri Jul 18, 2008 9:26 pm

There is a seperate stage available for this. You can find this store procedure stage under DATABASE section.

ray.wurlod · Post by **ray.wurlod** » Fri Jul 18, 2008 11:05 pm

Or you can call such a stored procedure from an ODBC Enterprise stage.

cnu · Post by **cnu** » Sat Jul 19, 2008 8:09 am

Thanks !!

ray.wurlod · Post by **ray.wurlod** » Sat Jul 19, 2008 3:35 pm

Can you mark this thread as Resolved?

DSXchange

Callingstor edprocedure in the datastage

Callingstor edprocedure in the datastage

Re: Callingstor edprocedure in the datastage