DSXchange

Hi all,

I am using a stored procedure stage in my job, In Stage-->General-->Database vendor i am not able to select Sybase, it shows only Oracle. Please give me a answer how to get sybase in my database ventor.

When i run my job it shows could not load dsstpora.dll

Hi

I think this would help you
"Database vendor. The type of relational database. With this release, the
option is Oracle. The default is empty, allowing you to identify the relational
database type at run time using a job parameter. Database vendor is
required."

Upgrade. The original release only supported Oracle but the latest 7.5.x versions added DB2 and Sybase.

chulett wrote:Upgrade. The original release only supported Oracle but the latest 7.5.x versions added DB2 and Sybase. ...

Hi its 7.5.X version

Which 'X'? Are you running 7.5x2 the version which allows PX jobs to run on Windows? If that's the case, you are out of luck until 8.0 is released from what I understand.

chulett wrote:Which 'X'? Are you running 7.5x2 the version which allows PX jobs to run on Windows? If that's the case, you are out of luck until 8.0 is released from what I understand. ...

Ya its a 7.5x2 windows version, I think i have to install the sybase client in my datastage server, correct me if my understanding is wrong because when i run the job its shows Dll can't be loaded.

It shows the Oracle dll can't be loaded. You cannot use that stage. Have you tried 'call'ing the SP in the before or after sql tab of the Sybase stage or using ODBC?

Magesh_bala wrote:Ya its a 7.5x2 windows version, I think i have to install the sybase client in my datastage server, correct me if my understanding is wrong because when i run the job its shows Dll can't be loaded.

Magesh_bala wrote:shows could not load dsstpora.dll

If you are talking about the above dll. Then, I believe it(dsstpora.dll) is more related to Oracle than Sybase.

I_Server_Whale wrote:

Magesh_bala wrote:Ya its a 7.5x2 windows version, I think i have to install the sybase client in my datastage server, correct me if my understanding is wrong because when i run the job its shows Dll can't be loaded.

Magesh_bala wrote:shows could not load dsstpora.dll

If you are talking about the above dll. Then, I believe it(dsstpora.dll) is more related to Oracle than Sybase.

Hey guys just conclude me whether i can use stored procedure stage in my job, Whether datastage 7.5x2 supports Sybase and DB2 in stored procedure stage.

chulett wrote:Which 'X'? Are you running 7.5x2 the version which allows PX jobs to run on Windows? If that's the case, you are out of luck until 8.0 is released from what I understand.

Craig already answered that.

STP stage with 7.5.1 A supports DB2, Oracle, and Sybase.
I guess 7.5.2 should support it too, unless they have taken it away. Which should not be the case.
Try to manually enter the Database name and check if it works.

Narasimha - they have 7.5x2 not 7.5.2 and they ain't the same thing. Asked and answered - they cannot use it for anything other than Oracle.

My thought was 7.5x2 came after 7.5.1.A, I assumed they would have carried it forward. Of course missed the "x" too. My ignorance!
Thanks for the clarification Craig.

how do i get Teradata in the Database vendor list?

You wait until IBM brings out a version of the Stored Procedure stage that supports Teradata.

If you can make a good business case (that is, one where IBM makes another squillion), you could submit an enhancement request.