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