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

I did review the article. I am still on V5R4. I have used the Technic to
copy the remote file to the local system. The problem is, the file is big
with 66 million records and the record size in larger than 2K. It's just
too bulky to do this way.

Using the INSERT and SELECT with a NOT EXISTS is much quicker.

Thanks

On Fri, Oct 17, 2014 at 2:37 PM, John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

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