Re: Can you suggest how I can connect to another database in SQL reading the remote file and updating a local file

On Fri, Oct 17, 2014 at 2:10 PM, Darryl Freinkel <dhfreinkel@xxxxxxxxx> wrote:

Judging from the comments, there is not a way to do this. I do not want to
write any code in RPG. If I did do it in RPG, I could simply use DDM. SQL
is so much quicker.

Actually, Glenn and Vern both mentioned ways to do it without RPG.
I'll repeat Glenn's link:

http://www.itjungle.com/fhg/fhg072512-printer02.html

Some key points from the article: (1) Uses new(ish) three-part naming
convention. (2) Relies on DRDA (so if this isn't set up, you have
some configuring to do first). (3) On older systems, you can use
QMQRY to copy the data over.

I can't tell if any of their suggestions are "quick enough" for you.

John Y.