Re: Using STRSQL against a DDM file

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

It's not allowed, Alan - I'm sure you will see a message to that effect 
in STRSQL.

Instead, find out what the file is that the DDM file points to and use 
remote SQL to get to it - that would include adding an entry to the 
relational database list - WRKRDBDIRE is the command to start with, I 
believe.

HTH
Vern

On 6/21/2011 7:53 AM, Alan Shore wrote:
> 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