Re: news400 goes negative on IBM? -- MIDRANGE-L

The ability to connect to DB2 on a PC (or other platform) is part of every iSeries. WRKRDBDIRE is the place to maintain this stuff. DRDA is the mechanism and, although no other DB vendor has provided a driver for it, IBM has for its DB2.

Once you have an entry for the DB2 remote system, the CONNECT TO... gets you there. Then any SQL statements, embedded or otherwise, go to that system and return the data to your RPG as if the data were local.

This is what IBM does with their Information Integrator (is that the name), which is a middleware piece running on a PC that is reachable through DRDA. It uses ODBC or OLE/DB itself (probably) to talk to other kinds of RDBMS'. But it's a lot more expensive than our product. ;-) From a C-Net article of May, 2003, announcing the release, DB2 Information Integrator costs $20,000 for a server license and $15,000 per data source to which an application connects. Maybe it's got cheaper by now - you think? And Oracle has a module they will sell you ($25,000?) that lets the iSeries talk to an Oracle DB

As to why would you want to connect to another RDBMS? The Mt. Everest answer works for me. The iSeries is no longer the only back-end DB server, much as we might want it to be. I know of instrument collection systems that use a custom version of SQL Server. Using a product like our RPG2SQL or IBM's Info Integrator or JDBC lets you say, "Sure, we can do that, no sweat." No more jumping through CSV/IFS/Excel hoops or sitting inside the iSeries fortress, wishing you could see what's outside the walls.

If you say that you cannot get to the data on other systems from the iSeries, guess where your company will go - away!

HTH
Vern

At 04:45 PM 5/20/2005, you wrote:

Yeah...I do it all the time...CONNECT TO...
On 5/20/05 01:49 PM, "Steve Richter" <stephenrichter@xxxxxxxxx> wrote:
> On 5/20/05, michael@xxxxxxxxxxxxxxxxxx <michael@xxxxxxxxxxxxxxxxxx> wrote: >> I can connect from my RPG program to a DB2 database on Windows or Linux. > > I did not know that. Is it something in SQL? > >> I can access MySQL from Perl or something I suppose. I can't imagine why >> I would want to access SQL Server. > > because the users want it. > >> What is the importance in being able to access different databases from >> RPG? I can see that that could be imoprtant for a Windows developer >> since there are so many databases out there, but why would one care >> about accessing SQL Server from RPG? >> >>> -------- Original Message -------- >>> Subject: Re: news400 goes negative on IBM? >>> From: Steve Richter <stephenrichter@xxxxxxxxx> >>> Date: Fri, May 20, 2005 1:10 pm >>> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> >>> >>> On 5/20/05, Neil Palmer/DPS <neilp@xxxxxxxxxxx> wrote: >>>> One can only hope that after selling off the Printing Division (Lexmark), >>>> Storage Division (Hitachi) and PC Division (Lenovo) that they might sell >>>> off the iSeries division. THEN we'd probably see some serious hardball >>>> promotion from the new owners, who may just revive the AS/400 name. >>> >>> Great idea to sell the as400 to another company! The new owners will >>> have a lot of work to do technically improving the system. In .NET I >>> can connect to the SqlServer, MySQL and iSeries database. An iSeries >>> RPG application can only use the iSeries database. That is IBM >>> management making that decision. >>> >>> -Steve >>> >>> -- >>> 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.