Re: DDM and SQL

["Mark Waterbury" <mark.s.waterbury@xxxxxxxxxxxxxxxx>]

Hi, Kirk:

I believe the answer is, if you use DDM, then all the records go
across...

But, native SQL has a way to do this; simply issue a CONNECT
to connect from your local machine to the remote "database", and
then run the query (SQL SELECT ... FROM ... WHERE ...) and
then, all the work is done on the target system and only the SQL
"results set" is returned...

Regards,

Mark S. Waterbury

----- Original Message -----
From: "Kirk Goins" <kirkg@pacinfosys.com>
To: "Midrange-L (E-mail)" <midrange-l@midrange.com>
Sent: Wednesday, October 09, 2002 4:22 PM
Subject: DDM and SQL


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

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.