Accessing another database from RPG via SQL -- RPG400-L

Subject: Accessing another database from RPG via SQL
From: Evan Harris <spanner@xxxxxxxxxx>
Date: Fri, 23 May 2003 07:41:58 +1200
List-archive: <http://archive.midrange.com/rpg400-l>
List-help: <mailto:rpg400-l-request@midrange.com?subject=help>
List-id: RPG programming on the AS400 / iSeries <rpg400-l.midrange.com>
List-post: <mailto:rpg400-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>,<mailto:rpg400-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>,<mailto:rpg400-l-request@midrange.com?subject=unsubscribe>

Hi All

I have a customer who has some programs that lookup a file via DDM to do some validation of things like Account number, gl code, etc etc and occasionally return data like account name. Now the remote AS/400 database is being migrated to db/2 running on a pSeries.

What do I have to do to achieve the same effect as the DDM files ?

I have read numerous posts regarding using SQL to access remote databases but am still a little unclear on how- I can:

- construct a simple SQL statement that returns a field or fields to replace what used to be a fairly simple chain - what the setup steps are for accessing a remote database using this method

Any step by step plans, hints, code snippets or printers to manuals are welcome.

Regards
Evan Harris

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Accessing another database from RPG via SQL , rob

This mailing list archive is Copyright 1997-2025 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.