Create a DDMF on the source machine to the target file.
Write a program to run on source machine to read the source table, perform selection...this could be done with SQL as it is all local and will not require the RDB entry. Write the selected row to the DDMF that points to the target machine's file.
This seems like it should get the desired subset of data from the source machine to the target machine.
Steve Needles
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of a4g atl
Sent: Thursday, August 10, 2017 8: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
CONFIDENTIAL: The information contained in this email communication is confidential information intended only for the use of the addressee. Unauthorized use, disclosure or copying of this communication is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by return email and destroy all copies of this communication, including all attachments.
midrange.com
