Store procedure stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 86
- Joined: Mon Nov 27, 2006 3:42 am
- Location: Wilmington
Store procedure stage
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
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
-
- Participant
- Posts: 86
- Joined: Mon Nov 27, 2006 3:42 am
- Location: Wilmington
-
- Participant
- Posts: 86
- Joined: Mon Nov 27, 2006 3:42 am
- Location: Wilmington
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.
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
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.
If you are talking about the above dll. Then, I believe it(dsstpora.dll) is more related to Oracle than Sybase.Magesh_bala wrote:shows could not load dsstpora.dll
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Participant
- Posts: 86
- Joined: Mon Nov 27, 2006 3:42 am
- Location: Wilmington
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.If you are talking about the above dll. Then, I believe it(dsstpora.dll) is more related to Oracle than Sybase.Magesh_bala wrote:shows could not load dsstpora.dll
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.
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
Craig already answered that.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.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
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.
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 Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
If you can make a good business case (that is, one where IBM makes another squillion), you could submit an enhancement request.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.