RE: how to query across different platforms

[vhamberg@xxxxxxxxxxx]

Just to clarify - I'm sure I'm not correct on the product name or feature - but one can google on DB2 and federated and get close. It's very cool in concept - can have a Sybase and a Progresql and mysql and sql server and iseries all defined and looking like one DB2 database. I think!!!

-------------- Original message -------------- 
From: vhamberg@xxxxxxxxxxx 

> Mark wants to JOIN tables from separate machines - you can't do that from the 
> iSeries. 
>
> DB2 for Windows has federation - lets you do just what Mark wants - but, as Rob 
> said, it's also the SPENDMONEY command. 
>
> -------------- Original message -------------- 
> From: "Eric Lehti" 
>
> > Command is (Add RDB Directory Entry) (ADDRDBDIRE) 
> > After setup, then in STRSQL, CONNECT TO 
> >
> >
> > (Add RDB Directory Entry) (ADDRDBDIRE) 
> > Entry: RDB 
> > Relational database . . . . . 
> > Relational database alias . . *NONE 
> > Remote location: RMTLOCNAME 
> > Name or address . . . . . . . 
> >
> > The Add Relational Database Directory Entry (ADDRDBDIRE) command 
> > allows you to add an entry to the relational database directory. 
> > Relational database (RDB) entries can represent local databases or 
> > remote databases. The RDB associated with an entry can also be 
> > classified as a system database or a user database. 
> >
> > There is only one system database per system. It is defined as the 
> > system auxiliary storage pool (ASP number 1) and configured basic 
> > user ASPs (ASP numbers 2-32). A system can be configured to have 
> > one or more user databases. A user database is defined to be an ASP 
> > group that is configured and available. Such a database is joined 
> > to the system database in such a way that all of the objects on the 
> > system database are also accessible through it. 
> >
> > Note: As used in this context, 'system' can refer a locical 
> > partition of an iSeries machine configured with multiple 
> > partitions. 
> > Local databases include the system database and any available user 
> >
> > databases on this system. Remote databases normally reside on 
> >
> > another system, but an unavailable ASP group configured on this 
> >
> > system is also considered to be temporarily remote, because it might 
> >
> > have been switched to another node within a cluster of systems. 
> >
> >
> >
> > Restriction: You must have execute authority to the application 
> >
> > requester driver program to specify the program on this command. 
> >
> >
> >
> > try (RDB) 
> >
> >
> >
> > Specifies the relational database name information. 
> >
> >
> >
> > Note: Valid relational database names and aliases must begin 
> >
> > with a letter and consist of uppercase A-Z, 0-9, and underscore. 
> >
> >
> >
> > Element 1: Relational database 
> >
> >
> >
> >
> > -----Original Message----- 
> > From: midrange-l-bounces@xxxxxxxxxxxx 
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark S. Waterbury 
> > Sent: Friday, April 25, 2008 12:26 PM 
> > To: Midrange Systems Technical Discussion 
> > Subject: how to query across different platforms 
> >
> > Hello, all: 
> >
> > I understand that it is possible to use JDBC (and ODBC) to access 
> > different database tables on different platforms. 
> >
> > But, is it possible to connect to one database and a table on i5/OS, and 
> >
> > simultaneously connect to another database to access a table on another 
> > platform, and then join these two tables? 
> >
> > Does anyone have any examples showing something like this, that you can 
> > share? 
> >
> > Thanks in advance. 
> >
> > Mark S. Waterbury 
> >
> > -- 
> > 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.