RE: Using STRSQL against a DDM file

Thanks for your reply Luis
Copying the DDM file to a local TEMP file will probably be the path I will take

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


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Rodriguez
Sent: Tuesday, June 21, 2011 10:04 AM
To: Midrange Systems Technical Discussion
Subject: Re: Using STRSQL against a DDM file

Alan,

I'm not very sure about this but, What would happen if you write a SQL proc or function that gets the search value, does the connect, gets the needed info, returns to the local DB and returns your needed value(s)? Would that work?

Also, (again, IIRC) DDM was really slow. Sometimes we just CPYF'ed the DDMF to a local TEMP file and then processed the temp file.

Regards,


Luis Rodriguez
IBM Certified Systems Expert - eServer i5 iSeries
--



On Tue, Jun 21, 2011 at 9:05 AM, Alan Shore <ashore@xxxxxxxx> wrote:

Thanks for your reply Vern
What you are saying is in fact what I am finding out The only problem
(unless I am wrong - which no longer surprises me) with using remote
SQL is that I won't be able to use files on the local system as well
as the DDM file.

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

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
Sent: Tuesday, June 21, 2011 9:21 AM
To: Midrange Systems Technical Discussion
Subject: Re: Using STRSQL against a DDM file

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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.