Re: Using STRSQL against a DDM file

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