Re: How can I speed up the copying of data using DDM and field selection. -- MIDRANGE-L

Subject: Re: How can I speed up the copying of data using DDM and field selection.
From: Buck Calabro <kc2hiz@xxxxxxxxx>
Date: Thu, 10 Aug 2017 14:50:53 -0400
List-archive: <http://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

On 8/10/2017 2:36 PM, Rob Berendt wrote:

This is highly subjective:

This takes forever to copy.

Will it be faster than "forever" to save just the desired rows to tape and
have that physically transferred? Much like transferring image catalogs
from IBM used to be before we tweaked our network.

An interesting thought.
SAVRSTOBJ might work too.

Or perhaps OP could force the selection to be done on the source side by
copying the subset of eligible rows to a temporary table, and copying
THAT to the DDMF?

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: How can I speed up the copying of data using DDM and field selection. , Rob Berendt

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