DSXchange

Hi,

Iam Using stored procedure stage in Datastage 7.5.1. I want to call Teradata stored procedure and procedure type is transform.

Can I call Teradata stored procedure because in the Database vendor it displays -- Oracle, DB2 and Sybase only.

I tried using these vendors I got the follwoing error.

Stored_Procedure_0,0: Error: Could not load dsstpsyb.so
Stored_Procedure_0,0: Error occurred in call to ORPHCallActivePluginInitialize().

Anybody help me here please.

Hi

Stored Procedue stage only support Oracle, DB2 and Sybase as you can these in the drop down box. I never tried calling stored procedure thro datastage, I think you have to construct user defined sql to call stored procedure