RE: DDM and SQL

Kirk

Are you thinking of DRDA? That's how SQL gets to another system. I believe
the statement is sent to the other system (probably in a DDM session) and
then the work happens remotely, with only the result passed back. Terms
like RUW and DUW (remote and distributed unti of work, resp.) are used
here, so I suspect the work is at the other end. Hope so, anyway.

Vern

At 04:28 PM 10/9/02 -0600, you wrote:

Kirk,
        When I use STRSQL or RUNQRY over a DDM file I get the message,
"QRY1609 - File PCRPACHR in PCRDDMFILE is not a data base file, cannot
query." Or "SQL7001 - File PCRPACHR in PCRDDMFILE not database file."


Thank you,
Matt Tyler
Mattt@wincofoods.com

-----Original Message-----
From: Kirk Goins [mailto:kirkg@pacinfosys.com]
Sent: Wednesday, October 09, 2002 16:22
To: Midrange-L (E-mail)
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?