|
RPG2SQL from RJS SOftware can do what you want. www.rjssoftware.com Paul Nelson Arbor Solutions, Inc. 708-670-6978 Cell pnelson@xxxxxxxxxx -----midrange-l-bounces@xxxxxxxxxxxx wrote: ----- To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx> From: "Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx> Sent by: midrange-l-bounces@xxxxxxxxxxxx Date: 05/20/2005 06:09PM Subject: RE: news400 goes negative on IBM? But it would be nice, if we had a windows partition, on the iseries, that we could load our odbc drivers, then have a (magical socket type app) that would work with embedded SQL within RPG, to make the database calls via an rpgsql program to this windows partion.. To process these odbc connections... And pass the data back and forth... But oh well... Tim -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Booth Martin Sent: Friday, May 20, 2005 2:59 PM To: Midrange Systems Technical Discussion Subject: Re: news400 goes negative on IBM? In order for RPG to reach other data bases wouldn't we have to work to the lowest common denominator? Would we loose triggers, indexed files, most file related commands, and dds? --------------------------------- Booth Martin http://www.martinvt.com --------------------------------- -------Original Message------- From: Midrange Systems Technical Discussion Date: 05/20/05 16:44:44 To: Midrange Systems Technical Discussion Subject: Re: news400 goes negative on IBM? Nah...if the iSeries is a backend database, then you don't need to have RPG access SQL Server. You may need to have C Flat access DB2 on iSeries...I understand that...but the reverse doesn't hold. Now, if you want to have applications that run on the iSeries access different databases, don't write those applications in RPG. Write it in Java. RPG is a language designed for IBM midrange systems to access IBM midrange systems. It was never developed to be cross platform or cross database. It's Report Program Generator for crying out loud. Sure, I can do a lot with RPG, and I do...but it's not the language for cross platform applications - it's the language for a centralized iSeries. On 5/20/05 01:51 PM, "Don" <dr2@xxxxxxxxxxxx> wrote: > > > simple. Most shoppes today are very hetereogeneous in systems and > database. It's not uncommon to see DB2/Oracle/Access/.net/SQL_Server > all > in the same shoppe or a combo thereof...and with it the need to talk > back > and forth in a realtime modality. Capice? Also, more and more shoppes > will tell you that their current new development efforts are in > .net/windows/etc and that they use DB2/400 as a backend database. > server....tell you anything about trends? > > Well, let's see, as for selling iSeries/i5/4i/as400...IBM IS now > listed on > the NY board as a services company as I recall..... > > Don in DC > > > On Fri, 20 May 2005 michael@xxxxxxxxxxxxxxxxxx wrote: > >> I can connect from my RPG program to a DB2 database on Windows or Linux. >> I can access MySQL from Perl or something I suppose. I can't imagine >> why >> I would want to access SQL Server. >> >> 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. . -- 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 e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy the message. -- 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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.