Re: Using STRSQL against a DDM file

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

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