DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54594
Location: Sydney, Australia
Points: 296048

Post Posted: Wed Jan 23, 2008 7:23 am Reply with quote    Back to top    

If it's any consolation, I think we ALL got caught by it at some point.

Who reads all that legalese stuff anyway?

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
flashgordon



Group memberships:
Premium Members

Joined: 17 Aug 2004
Posts: 99
Location: Boulder, Colorado
Points: 1188

Post Posted: Wed Jan 30, 2008 1:28 pm Reply with quote    Back to top    

Kenneth,

Thanks. It looks like we are going to need alternatives and you gave us some good ones.

Just to completely close this thread out. Last night IBM Ascential support confirmed to me that you need a "Full licence" from Data Direct to use Data Direct odbc calls like the one's I show above in Datastage Basic.

I will informally answer the next quesion in your mind. How much do the full Data Direct odbc licenses cost? I am pretty sure Data Direct was saying if you have serious Unix servers with 4 or more cpu's, it would be at least $10k a machine and probably a lot more.

.. Tom

_________________
Flash Gordon
Hyperborean Software Solution
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54594
Location: Sydney, Australia
Points: 296048

Post Posted: Wed Jan 30, 2008 4:13 pm Reply with quote    Back to top    

From memory it's a lot more. I think pricing is available on their web site.

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
flashgordon



Group memberships:
Premium Members

Joined: 17 Aug 2004
Posts: 99
Location: Boulder, Colorado
Points: 1188

Post Posted: Sat Feb 02, 2008 5:53 pm Reply with quote    Back to top    

Hi,

I really apologize for this but all that is said about this problem above is not true. IBM Ascential support came back and said that Datastage Basic (Ray calls it BCI) is OK for Data Direct calls. If you want to use Data Direct with C++ or Perl you have to buy a "Full" Data Direct License. But if you are using Datastage licensed software (the stages, BCI, ...) you have the license if you bought datastage. Add these two lines to you Datastage Basic (BCI) program and this problem will go away:

DEFFUN DSAttachODBCDriver(hDBC)
Status = DSAttachODBCDriver(hDBC)

Ray I don't know how you feel about this but maybe you should add these two lines to some of the samples in DSxchange that show how to use BCI. I don't think these lines hurt anything and they solve this problem. I know we got our template from DSxchange.

There was a little discussion about this line in .odbc.ini. It was felt this line should be removed and had something to do with the licensing problem:

QEWSD=39422

I tried to remove it and just running a datastage job with BCI put it back in .odbc.ini (I have never seen running a job change a config file but .odbc.ini changed when I ran a job. But even with QEWSD=39422 in .odbc.ini , putting the 2 lines above in your Datastage Basic/BCI routine will fix this problem.

... Flash

_________________
Flash Gordon
Hyperborean Software Solution
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54594
Location: Sydney, Australia
Points: 296048

Post Posted: Sat Feb 02, 2008 10:36 pm Reply with quote    Back to top    

DSAttachODBCDriver() function is not documented in the DataStage BASIC manual nor anywhere else that I can find. Do you have any more information about it? I will reply off-line about QEWSD (or ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
kcbland

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 15 Jan 2003
Posts: 5209
Location: Lutz, FL
Points: 39192

Post Posted: Sun Feb 03, 2008 2:06 pm Reply with quote    Back to top    

Hey Flash, just so you know, Ray is correct from the historical perspective. If you search the forum you will see that for years people have experienced this issue (since DataDirect drivers were intr ...

_________________
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54594
Location: Sydney, Australia
Points: 296048

Post Posted: Sun Feb 03, 2008 9:27 pm Reply with quote    Back to top    

A VLIST of the DSAttachODBCDriver() function shows that it quite simply checks the licensing. I suspect there's something more - involving the QEWSD entry - but am not prepared to go public with that ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
flashgordon



Group memberships:
Premium Members

Joined: 17 Aug 2004
Posts: 99
Location: Boulder, Colorado
Points: 1188

Post Posted: Mon Feb 04, 2008 11:04 am Reply with quote    Back to top    

Kenneth,

First of all I want to qualify something I said earlier. The entire thread up to a a certain point was not incorrect. I think our license did expire after 30 days as Ray and that other gentleman pointed that out. That was an important point and I was able to keep formal support on the right track when they were more interested in some recent Oracle patches we had done which was barking up the wrong tree.

I will say that I checked the two new lines carefully. I inserted them at the top of the routine (above the alloc), the odbc error message went away, and I checked the oracle table and the update was done. The two new lines definitely solve the problem.

Finally I want to say that I'm totally impressed with what Ray and his band of musketeers say about any problem and I always consult with them first when I'm stuck with something important. I understand that without access to the Datastage source code there's only so far they can go with certain problems.

... Flash

_________________
Flash Gordon
Hyperborean Software Solution
Rate this response:  
Not yet rated
kcbland

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 15 Jan 2003
Posts: 5209
Location: Lutz, FL
Points: 39192

Post Posted: Mon Feb 04, 2008 12:07 pm Reply with quote    Back to top    

Musketeers, ehh? Laughing I kind of like that.

_________________
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54594
Location: Sydney, Australia
Points: 296048

Post Posted: Mon Feb 04, 2008 4:41 pm Reply with quote    Back to top    

Embarassed Quelle embarrasant!

But not "my" band, please! DSXchange is Dennis's baby, I've just been sharing some of my good fortune (of having worked for the vendor for some years) on DSXchange.

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43085
Location: Denver, CO
Points: 222463

Post Posted: Mon Feb 04, 2008 6:33 pm Reply with quote    Back to top    

[raises hand] Umm... I'd like to be a Musketeer. Wink

_________________
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54594
Location: Sydney, Australia
Points: 296048

Post Posted: Mon Feb 04, 2008 6:50 pm Reply with quote    Back to top    

chulett wrote:
[raises hand] Umm... I'd like to be a Musketeer. Wink
Artos, Porthos or D'Artagnan?

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43085
Location: Denver, CO
Points: 222463

Post Posted: Mon Feb 04, 2008 8:31 pm Reply with quote    Back to top    

Hmmm... so is Aramis already spoken for?

_________________
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54594
Location: Sydney, Australia
Points: 296048

Post Posted: Mon Feb 04, 2008 9:39 pm Reply with quote    Back to top    

It got disqualified when they named a perfume thus.

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43085
Location: Denver, CO
Points: 222463

Post Posted: Mon Feb 04, 2008 10:51 pm Reply with quote    Back to top    

Laughing

_________________
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours