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

Let me clarify what I mean by source and target.

Source = system to get data from, i.e. production.
Target = system data to be copied to i.e. development system.

You cannot use SQL on a DDM file. The OS throws out an error message.

So what I need to achieve is running a SQL statement that will execute on
the production/source system and then transfer the selected records over
the wire.

The 2 machines are on the same network and are side by side.

Dieter's solution is the closest I have as a viable option. Guess I am
about to learn how to run Java i2i.

Darryl


On Fri, Aug 11, 2017 at 10:53 AM, D*B <dieter.bender@xxxxxxxxxxxx> wrote:

<Steve>
I'm not using SQL against a DDMF...use SQL against the source file...this
process is running on the source machine, not the target. So the SQL will
work against the source file.

I'll be more clear.

Use SQL to create an SQL cursor against the source file on the source
machine.

Read the cursor and write the selected row to the DDMF using the HLL
program's IO functions (not SQL).

When the row is written to the local DDMF, the data will go to the target
machine's file.
</Steve>

Creating a DDM file on a production machine, creating and running a
programm on a production machine, transferring data to a test machine -
this might hardly be sox compliant.

D*B
--
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