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

For SOX reasons, I have no access other than READ rights.

Darryl

On Thu, Aug 10, 2017 at 9:53 AM, Paul Therrien <
paultherrien@xxxxxxxxxxxxxxxxxx> wrote:

Can you copy the data on the other system to a temporary file on that
system, selecting the records you want, and then copy the temp file to the
target system?


Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
a4g
atl
Sent: Thursday, August 10, 2017 9:44 AM
To: midrange-l@xxxxxxxxxxxx
Subject: How can I speed up the copying of data using DDM and field
selection.

We do not have a relational database entry for our production system so I
cannot use SQL to copy data from the production system.

I am using DDM and CPYF with field testing. The problem is I am trying to
copy 100k records from a file that has over 800 million records. CPYF does
not do the selection on the source system and instead appears to copy all
800 million records to the test system where it checks the values and
either
writes the records or discards them. This takes forever to copy.

I have read rights to the file on the source system.

Is there another way to speed up the copy?

TIA

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
http://amzn.to/2dEadiD

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD