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 thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].