Using ODBC connection via DS Basic

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Using ODBC connection via DS Basic

Post by roy »

Hi all,
in previous versions there was an ODBC header file in the dsinclude folder under each project.
I now notice on a 8.5 installation that this file is no longer there.

does that mean that we can no longer use a Basic routine/job control to use the DS Basic language to connect and utilize the odbc connection to the DB ?

Thanks for your time :),
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Use this one.

Code: Select all

$INCLUDE UNIVERSE.INCLUDE ODBC.H
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Thanks Ray,
So that is the new/correct location now a days?

I do recall it being under ther dsinclude few versions back.

Cheers,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The UNIVERSE.INCLUDE location has been available since version 1.0.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

ray.wurlod wrote:The UNIVERSE.INCLUDE location has been available since version 1.0.
Not saying it wasn't.
A few (maybe more) versions back there was also an odbc.h under the include main directory.
Now I seen its a miss from that location
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

So have you found it elsewhere?
-craig

"You can never have too many knives" -- Logan Nine Fingers
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

back in the old days (not V1 but V 4.2.1)
I had the ODBC.H in the regular include directory
maybe it was a version fluke :roll:
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Post Reply