Hi Roy
As others have said, there are distinct differences. You can't run RPG programs on AIX - and RPG of any vintage is not a language that can compile onto AIX.
In addition, your RPG program needs the Db2 RDBMS that is integrated to IBM i (current name for AS/400 or iSeries or ...). IBM do have a verstion of Db2 that runs on AIX, but you have to pay for it.
If you are going to process things and communicate results to AIX, you might do what Jack suggested - use web APIs to call your RPG from AIX- you probably need to get your RPG up to date - RPG III is ancient.
IBM i can also pull data from your ProgresSQL using JDBC, probably. There is a project called ArdGate, I think, that lets you set up JDBC connections and use them like native IO in RPG - you still probably want a newer IBM i, or at least update the OS.
Options galore, just a different path than you might first have anticipated.
Good luck!
Vern
On Thu, 18 May, 2023 at 11:02 AM, Roy Luce - Long Pier Solutions <lwl@xxxxxxxxxxxxx> wrote:
To: 'midrange systems technical discussion'
Not a switch; more of an extension.
A multi-plant client, running the application, supports all their US plants and distribution locations off a single iSeries. Their Canadian operations would like to use my application but they run AIX, the VARNET application, and the Progress DB.
Roy Luce
Direct – 847-910-0884
833-937-8368
Email – lwl@xxxxxxxxxxxxx<mailto:lwl@xxxxxxxxxxxxx>
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx<mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx>> On Behalf Of Peter Dow
Sent: Thursday, May 18, 2023 10:48 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: OS400 vs AIX
Hi Roy,
It sounds like you have a working application. What is the reason for the switch?
--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx<mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx<mailto:pdow@xxxxxxxxxxxxxx> rr/
On 5/18/2023 7:09 AM, Roy Luce - Long Pier Solutions wrote:
In response to Jack Woehr's request for a further description of the application:
The referenced application, written in RPG3, extracts supply and demand info from MRP databases, then builds a proprietary reporting database. The reporting database is moved off the iSeries to an SQL server which supports the users' reporting requirements.
The application does not have any transactions - MRP supplies the transactions. Its database is basically a snapshot of a manufacturer's inventory and production requirements at the time it is run.
Roy Luce
Direct – 847-910-0884
833-937-8368
Email –lwl@xxxxxxxxxxxxx<mailto:lwl@xxxxxxxxxxxxx>
-----Original Message-----
From: MIDRANGE-L<midrange-l-bounces@xxxxxxxxxxxxxxxxxx<mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx>> On Behalf Of
Jack Woehr via MIDRANGE-L
Sent: Thursday, May 18, 2023 8:33 AM
To: Midrange Systems Technical
Discussion<midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>>
Cc: Jack Woehr<jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx<mailto:jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>>
Subject: Re: OS400 vs AIX
It really depends on what the application does. Do you want to describe it further, Roy?
On Thu, May 18, 2023 at 7:05 AM Roy Luce - Long Pier Solutions <lwl@xxxxxxxxxxxxx<mailto:lwl@xxxxxxxxxxxxx>> wrote:
I have an iSeries application, written in ILE, which runs in the
OS400/DB2 environment.
What does it take to run that same application in an AIX//Progress DB
environment?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx> To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.
midrange.com
