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.
Have you tried searching the forum? Check these. LINK1 and LINK2.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.