Uh, have you looked at CRTDDMF command lately? If you specify TYPE *IP,
the ports referenced for the remote database are defaulted to *DRDA....
Seems to me that adding an entry to your RDB Directory should let you
create DDM files to Informix, though I've never tried.
If the DDM object won't work, then you could always fall back to CONNECT
TO informixServer....
Using SQL to remotely access the data does have some limitations,
especially when you need to use local AND remote data in a SELECT.
Normally, I would just connect to the remote, create a local copy in my
QTEMP, close the connection, then process the SELECT locally. Not very
efficient, but it does work...
Hth,
Eric DeLong
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Cunningham
Sent: Friday, February 13, 2009 9:09 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Running AIX in a partition
I had forgotten about DRDA. So if I had an RPG app today that was
reading a DB2/400 table using embedded SQL I should be able to add a
CONNECT TO statement in front of any SELECT I might be doing and read
that table from any remote database that supports DRDA. (With the
assumption that the table name and columns are identical on the two
systems).
<pondering>
I wonder how hard it would have been for IBM to have merged DDM files
and DRDA so I could create a DDM file that points to a report DRDA
database and do a CHAIN in my RPG and have the DDM+DRDA process convert
that to an SQL select and pass my RPG back what it thinks is a local DB2
file.
</pondering>
.. now if only Microsoft would provide a native DRDA protocol to MS SQL
server.....
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Friday, February 13, 2009 9:09 AM
To: Midrange Systems Technical Discussion
Subject: Re: Running AIX in a partition
I believe Informix supports DRDA, so it should be as easy has setting up
the remote DB in the directory and using an SQL CONNECT TO.
It wouldn't matter where the AIX system is.
Charles
On Fri, Feb 13, 2009 at 8:38 AM, Mike Cunningham <mcunning@xxxxxxx>
wrote:
Is anyone running AIX in a partition on their iSeries? Does doing so
make it any easier to access data in the AIX partition from applications
running in an i5/os partition? In particular in the AIX partition
application was using Informix for a database could an RPG application
access that database any easier than if AIX was running on its own
hardware? I would still think that the RPG app would need to be doing
ODBC/JDBC type of connections to get data from Informix and not RPG "F"
spec or even RPG embedded SQL.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
