Teradata stored Procedure error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
forboy
Participant
Posts: 13
Joined: Tue May 04, 2004 12:03 pm

Teradata stored Procedure error

Post by forboy »

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.
rasi
Participant
Posts: 464
Joined: Fri Oct 25, 2002 1:33 am
Location: Australia, Sydney

Post by rasi »

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
Regards
Siva

Listening to the Learned

"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Post Reply