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

[a4g atl <a4ginatl2@xxxxxxxxx>]

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