DataBase vendors not available in SP stage

sumesh.abraham · Post by **sumesh.abraham** » Wed Jan 24, 2007 12:45 am

Hi All,

I'm using DataStage 7.0. When i use a Stored Procedure stage, the Database vendor drop down contains only Oracle. It doesn't have DB2 and Sybase listed. Please let me know the problem and possible solutions.

Thanks,
Sumesh

I_Server_Whale · Post by **I_Server_Whale** » Wed Jan 24, 2007 1:16 am

Have you tried searching the forum? Check these. LINK1 and LINK2.

kumar_s · Post by **kumar_s** » Wed Jan 24, 2007 1:49 am

Version 7 will support only Oracle.

sumesh.abraham · Post by **sumesh.abraham** » Wed Jan 24, 2007 2:00 am

Guys,
Thanks for the replies

kumar_s · Post by **kumar_s** » Wed Jan 24, 2007 2:05 am

You can alternatively use DB2 stage to call SP. You can mark the topic as you found a workaround.

chulett · Post by **chulett** » Wed Jan 24, 2007 8:02 am

Or upgrade... well worth it.

DSguru2B · Post by **DSguru2B** » Wed Jan 24, 2007 8:31 am

Stored procedures can be called in the before/after sql tab of database stages. If your stored procedure executes once and has no OUT or RETURN parameters then you can live without the STP stage. Else an upgrade is a better way to go. You might also want to look into the ODBC stage. But even that stage has limitations as it can only support IN INOUT parameters.