using STP stage with Sybase

jagadhish · Post by **jagadhish** » Thu Apr 13, 2006 11:15 pm

Hi,

I'm using DAtastage 7.5.1.A, from documentation i can see that STP stage supports Sybase. I'm using STP stage to call a Sybase stored procedure, but while excecuting the job I'm getting the following error message,

Stored_Procedure_0: ct_connect

ServerNotFound

Could anyone tell me reason for this and also what should be given for "Data source name" and "Database name" in the General tab in STP stage properties.

Any help orsuggetions are greatly appreciated.

Thanks,
Jags

chulett · Post by **chulett** » Fri Apr 14, 2006 6:23 am

I'm sure the documentation would discuss how to set this stage up for each db vendor. Have you connected to Sybase via DataStage before this? Do you have the Sybase OC installed on your DataStage server?

narayana_382 · Post by **narayana_382** » Wed Sep 13, 2006 8:51 am

Hi Craig,

I am able to connect to Sybase from the Sybase OCI stage and execute the Stored Procedure but when I use the STP stage and call the Sybase Stored Procedure job gets aborted with the above reason mentioned by Jagdish.

Your assistance in this regard is highly appreciated.

Thnks,
Nari

Ultramundane · Post by **Ultramundane** » Wed Sep 13, 2006 9:17 am

I am able to use STP with Sybase. However, I have an open case with Ascential for over 1 year now because dscapiop does not function properly with the STP stage and causes tremendously slow performance when dealing with any significant amount of data. The current workaround is to use the Sybase OC stage. This same issue exists for all DBMS's that can be accessed via the STP stage.