RE: SQL Across Multiple AS400's

You can but there are two problems with DDM files: Performance stinks
when you need to do lots of IO and if you have some sort of connection
problem, the only way to recover is to end the job.

BTW, if you search the archives for CONNECT TO, I'm sure you'll find
some sample code (there may also be some stuff on the WEB-400L list). I
know this has come up before.

Matt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Kurt Anderson
Sent: Friday, December 15, 2006 8:34 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: SQL Across Multiple AS400's

You could create DDM files.  I really don't know much at all about DDM
files, but they are like pointers to a file on another system I guess,
but you treat them as a normal file.  Can't SQL DDM files though.  I
also don't know if you can have multiple DDM files, each pointing to a
different system.  Something to look into though. 


Kurt Anderson
Application Developer
Highsmith Inc

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom Huff
Sent: Friday, December 15, 2006 12:35 AM
To: 'RPG programming on the AS400 / iSeries'
Subject: SQL Across Multiple AS400's


Does anyone have an example of how to get information from files from
multiple AS400's with SQL ?
Thanks
Tom