DDM and SQL

["Kirk Goins" <kirkg@xxxxxxxxxxxxxx>]

OK you database and DDM Gurus...

I'm not looking for a why or why not to do this, I'm looking for HOW it does 
it..

Let's assume on a local machine I use SQL to select say 5,000 records from say 
a 100,000 record file and assuming that the query optimizer uses a seq read to 
get those 5,000 records... there is lots of I/O

Now Let's move the data to a remote system and use DDM. Does the machine with 
the ACTUAL DATA do all the work and only return the 5,000 records across the 
link or does EVERY Record get passed via DDM the source machine which throws 
out the unwanted?



__________________________________________________
Kirk Goins
IBM Certified iSeries Technical Solutions Expert
IBM Certified Designing IBM e-Business Solutions
Pacific Information Systems - An IBM Premier Business Partner
503-674-2985           kirkg@pacinfosys.com