× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi Frank

Figured you knew that stuff, just threw it out just in case.

One expensive solution is IBM federation support - I think it's part of their Information Integrator or Data Integrator or whatever - makes several remote databases all look like one DB2 instance on a PC.

I do forget - is there any point to maybe bringing a chunk of data to the program, store it somewhere, change connections, get some more, store again, process? Again, ugly!

Later
Vern

frank kolmann wrote:
Hi Vern

Thakns for your reply.

date: Sun, 14 Dec 2008 19:39:42 -0600
from: Vern Hamberg <vhamberg@xxxxxxxxxxx>

SQL can easily handle files across partitions - just use WRKRDBDIRE to
add relational database directory entries for your other partitions.
Then you can connect to any of them, albeit one at a time.

As I said, I use REMOTE SQL successfully. I know how to do this.
As you said 'albeit one at a time.' , is my problem. With Remote SQL one
can access ONLY ONE PARTITION at a time. It is NOT POSSIBLE to
TRANSFER data or get at data from MULTIPLE partitions, AFAIK, using
REMOTE SQL, except via the technique of passing data as a parameter.

Ideally I want to assess files from ANY partition just like one can
access files from a SINGLE partition.

If I am missing something obvious I would be most grateful to be shown
what I am going wrong. What I sometimes resort to is to use FTP to
transfer data from the various partitions to temporary files then do the
SQL updates then FTP the data back and apply the updates,
but this is way to kludgy.

FWIW I noticed an article by Scott Klement where he uses JDBC
drivers to access SQL data bases. I intend to see if this may do
what I need but I am not very hopeful.

When we install a HA system I reckon I may be able to use its
remote journaling function to achieve the goal of updating
files in multiple partitions, and in this case I would NOT NEED
Remote SQL at all. BTW, would Remote Journals do
what I need.

Regards
Frank Kolmann

HTH
Vern

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.