ODBC FROM iSeries - huh?

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

OK, I've seen several posts like the following:

>However, the iSeries can access outside data sources through DDM or ODBC.

which claim that the iSeries can use ODBC to access data on another machine.
IIRC there was even a thread about this the other week. However, can someone
please explain this to me? I'm familiar with the SQL CLI, but that is a
method for interfacing with the database layer in a platform independent
manner, NOT a facility for accessing data on another machine.

As I understand the SQL CLI I could write a C program on the iSeries that
used the SQL CLI to access the database. In theory I could then take that C
source code and compile it in Windows and it would access ODBC. Fine, but
that is not the same as saying that the iSeries can access data using ODBC.

What I want to know is the following: Can I take my SQLServer or Oracle or
MySQL or ... ODBC drivers and load them on the iSeries so my programs can
access data on these remote machines. I think not, but others seem to feel
differently, please explain.

-Walden


------------
Walden H Leverich III
President
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@TechSoftInc.com
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)