Store procedure stage

Magesh_bala · Post by **Magesh_bala** » Sun Jan 28, 2007 10:29 pm

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

pradkumar · Post by **pradkumar** » Sun Jan 28, 2007 10:36 pm

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."

chulett · Post by **chulett** » Sun Jan 28, 2007 10:39 pm

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

Magesh_bala · Post by **Magesh_bala** » Sun Jan 28, 2007 10:57 pm

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

chulett · Post by **chulett** » Sun Jan 28, 2007 11:05 pm

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.

Magesh_bala · Post by **Magesh_bala** » Sun Jan 28, 2007 11:10 pm

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.

chulett · Post by **chulett** » Sun Jan 28, 2007 11:13 pm

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?

I_Server_Whale · Post by **I_Server_Whale** » Sun Jan 28, 2007 11:15 pm

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.

Magesh_bala · Post by **Magesh_bala** » Sun Jan 28, 2007 11:19 pm

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.

I_Server_Whale · Post by **I_Server_Whale** » Sun Jan 28, 2007 11:21 pm

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.

narasimha · Post by **narasimha** » Sun Jan 28, 2007 11:23 pm

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.

chulett · Post by **chulett** » Sun Jan 28, 2007 11:25 pm

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.

narasimha · Post by **narasimha** » Sun Jan 28, 2007 11:32 pm

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.

y2ariyas · Post by **y2ariyas** » Sun Feb 04, 2007 3:06 pm

how do i get Teradata in the Database vendor list?

ray.wurlod · Post by **ray.wurlod** » Sun Feb 04, 2007 4:16 pm

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.