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

Steve,

One, if you try to use SQL against a DDM file, you will get SQL7011
DSPMSGD RANGE(SQL7011) MSGF(QSQLMSG)

Two, if you could use sql against this DDM file it would probably still
suck the data down to the target machine, do the row selection, and still
have the crappy performance of CPYF with selection parameters. Doing RPG
I/O would also have this issue. Remember he wants <1% of a table with
millions of rows.

The goal is to cut down the number of I/O's coming across the comm line.

Until sql statements run on IBM i have some sort of "openquery" technique
to have the sorting/selection to be ran on the remote system to only pipe
down the desired rows you're limited to the other techniques presented,
such as:
- subsetting the data on the source to a temp file and they having the
remote system download that
- using sql on the target to call a stored procedure on the source which
only returns the desired rows
- creating an index or view which only returns the desired rows and
querying that.


Rob Berendt