Running the ODBC driver from Basic in DataStage

JeanPierreHaddad · Post by **JeanPierreHaddad** » Mon May 09, 2005 4:33 am

Hello everyone

A couple of years ago, I was checking this subroutine which comes in the documentation of DataStage and executes a SQL command directly through the ODBC driver. The exercise was interesting and proved to work under certain conditions. I used Version 6.0 of DataStage. The main benefit of this routine was to address directly a table in Oracle 9 and extract the data returned by a SELECT statement, for further usage in a Basic program. .

My questions are:
1. Has anyone tried a similar routine?
2. Has anyone used this approach in Version 7.5?

Thanks for your input.
Jean-Pierre

WoMaWil · Post by **WoMaWil** » Mon May 09, 2005 5:42 am

Bonjour Jean-Pierre,

since about two years people, who have used this feature with success in their routines complain, that it doesn't work anymore because Ascential and/or Merant implemented something to prevent this.

Wolfgang

JeanPierreHaddad · Post by **JeanPierreHaddad** » Mon May 09, 2005 6:31 am

Guten Tag Wolfgang

This is correct, there is some tricky counter which prevented the usage of the routine since Merant acquired the rights on the software driver. But there is also a way to neutralize this trick.

If all people gave up on the usage of this routine this is most unfortunate. My 2nd question remains for some individuals who have tried it on version 6.

Is there a politically correct solution (from the point of view of Merant / Ardent..Ascential..IBM) which permits the execution of an SQL statement and the reading of the resulting data in a concurrent environment?

Jean-Pierre

chulett · Post by **chulett** » Mon May 09, 2005 6:35 am

Of course there's a 'politically correct solution' for this - license (i.e. buy) the ODBC drivers for use outside of DataStage.

JeanPierreHaddad · Post by **JeanPierreHaddad** » Mon May 09, 2005 6:41 am

This sounds like a great answer. If few bucks can solve a technical problem and help make the wise decisions in a multi-million (add your own currency here) project, we will go for it.

Now let me rephrase my question:
For all those who bought the licensed driver, are there any who use it with version 7.5?

Or is there a representative of Merant or DataStage who can certify that the license will permit the execution of the routine without any problem? (refund garanteed?)

Jean-Pierre

kcbland · Post by **kcbland** » Mon May 09, 2005 8:06 am

The main benefit of this routine was to address directly a table in Oracle 9 and extract the data returned by a SELECT statement, for further usage in a Basic program.

The same effect can be achieved thru a system command call to sqlplus. It's a whole lot cleaner, uses Oracles client software to manage connections, is fully supportable thru Oracle, and FREE.

ogmios · Post by **ogmios** » Mon May 09, 2005 10:53 am

If you register the driver of the client database software in "branded_odbc" it also seems to work. You don't use the Merant driver, only the driver delivered with the database client software.

Ogmios