× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.