RE: Accessing another database from RPG via SQL

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

I think it's as simple as adding the RDB database entry.  It supports both
SNA or TCP/IP connectivity.  WRKRDBDIRE.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Evan Harris [mailto:spanner@xxxxxxxxxx]
Sent: Thursday, May 22, 2003 2:42 PM
To: RPG programming on the AS400 / iSeries
Subject: Accessing another database from RPG via SQL


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

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.