I have gone back through this thread to see what the OP was looking for, and he just wants to access data from DDM files and local files using SQL. Didn't say it had to be in the same statement, but if that is indeed what he wants, even DB2 Multisystem won't help. He needs a federation server to do distributed request queries. DB2 only supports federated databases via DB2 UDB. That has to run on a Windows or Linux box.
Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx
-----midrange-l-bounces@xxxxxxxxxxxx wrote: -----
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
From: "DeLong, Eric"
Sent by: midrange-l-bounces@xxxxxxxxxxxx
Date: 06/24/2011 12:00PM
Subject: RE: Using STRSQL against a DDM file
He wouldn't eliminate the DDM if it did what he wanted. What he wants to do is a distributed query (as in DB2 Multisystem) using data stored on local and remote servers.
I don't know anyone who has used DB2 Multisystem, so I have no practical advice. The docs for this are here:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=%2Fdbmult%2Frzaf3kickoff.htm
-Eric DeLong
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of McGovern, Sean
Sent: Friday, June 24, 2011 2:56 AM
To: Midrange Systems Technical Discussion
Subject: RE: Using STRSQL against a DDM file
Bill was eliminating DDM. Instead, use DRDA to connect to the remote
database and read the data (that the DDM was pointing to) directly.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
Sent: 23 June 2011 16:54
To: Midrange Systems Technical Discussion
Subject: Re: Using STRSQL against a DDM file
Probably, otherwise I'm very confused.
But the problem remains - how to combine, or whether to try to combine,
DDM access to remote data and SQL. Actually, I'm told, DRDA, which is
the mechanism for remote data access with SQL, is built on (or is the
foundation of) DDM - I hear both stories. At any rate, they are closely
related. But SQL doesn't allow the use of DDM files, period.
Hope we hear more from Bill!
Vern
On 6/23/2011 10:26 AM, Mark Murphy/STAR BASE Consulting Inc. wrote:
I suspect that he is referring to the remote file that the DDM file is
pointing to. Not source as in source code, but the source of the data.
Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx
-----midrange-l-bounces@xxxxxxxxxxxx wrote: -----
To: Midrange Systems Technical Discussion<midrange-l@xxxxxxxxxxxx>
From: Vern Hamberg
Sent by: midrange-l-bounces@xxxxxxxxxxxx
Date: 06/23/2011 10:13AM
Subject: Re: Using STRSQL against a DDM file
Hi Bill
Can you explain this more? As far as I know, a DDM file is local and
points to a file on a remote system. And doesn't have source.
So I'd like to learn what you refer to, as it might be useful.
Thanks
Vern
On 6/21/2011 8:18 AM, Bill Erhardt wrote:
Did you try to connect to the remote system and read the source of
the
DDM file directly?
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Tuesday, June 21, 2011 8:53 AM
To: 'midrange-l@xxxxxxxxxxxx'
Subject: Using STRSQL against a DDM file
Morning all
On one system (system A), I have a DDM file connecting to another
system
(system B)
I have to pull data from this DDM file on system A, but when
attempting
this in STRSQL, I get the message
File not table, view, or physical file.
Which is true
I have attempted to use an OVRDBF with the same result
I have used CPYF and copied this DDM file to another file and was
able
to use this CPYF file, but I was wondering if anyone had found a way
to
use SQL against a DDM file?
As always, all responses MUCH appreciated
Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill
--
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.
--
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.
midrange.com
