RE: iSeries and Sharepoint portal

True - but if the remote column pointer was there it could make things much easier. For example we have all our employee data in DB2/400 except for a ID card picture which is in another database. We could read the DB2 employee file and then code the JDBC to go get the picture or have a process that uploaded the picture to DB2 but if DB2 had the pointer option the DB2 employee file could have a picture field that pointed to the JDBC accessible table and the iSeries app would not need to know anything about where it actually resided. Like using a DDM file to point to a remote DB2/400 database. And if the remote database location ever changed it would just be changing the pointer not recoding all the apps that used JDBC

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Chris Bipes
Sent: Wednesday, August 08, 2007 11:50 AM
To: Midrange Systems Technical Discussion
Subject: RE: iSeries and Sharepoint portal

No it cannot. IBM wrote drives for DB2 to run on just about everything.
Microsoft writes drives for MS SQL for Microsoft OS only. But using
JAVA OBDC you can have an iSeries directly connect to a SQL database.

Chris Bipes
Director of Information Services
CrossCheck, Inc.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Cunningham
Sent: Wednesday, August 08, 2007 8:47 AM
To: Midrange Systems Technical Discussion
Subject: RE: iSeries and Sharepoint portal

Now that's an interesting idea. Did a quick google search and found
this. Looks like SQL server can link to DB2/400

http://msdn2.microsoft.com/en-us/library/aa964120.aspx

DB2/400 can't do the same can it? Link to a remote SQL server

--
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.