× 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.



Vern,

first of all: ArdGate is Open Source under GPL License, in other words: its
free and non commercial.
ArdGate uses another approach than RPG2SQL, comparable to Oracle Access
Manager for AS/400. The main diffrence in functionality is, that ArdGate
enables Connectivity to all Databases providing a JDBC driver. Its a pure
Java universal Database driver, a bridge between the *ARDGATE interface (also
known as "Client Integration Exit") and JDBC. The RPG Connector is running on
the AS400, the Java Process could run on AS/400 too, or on any other Java
Plattform. From the AS/400 perspective the remote database is handled as anyy
other remote DRDA capable database, in other words: you could use normal SQL
statements with all supported SQL interfaces on AS/400!
Using dynamic SQL, AS/400 will not see what you are doing with the remote
database and it will let pass any statement and bring back the SQLSTATE
(internal translated to a sqlcode) and the data the remote database delivers.
If the remote database has capabilities, as400 doesn't have, as far as the
returned resultset is compatible with DB2/400 (some limitations: no BLOB max
precision 31), it would be possible to get it delivered in Host Variables, or
presented in interactive SQL.

Dieter
Am Donnerstag 09 September 2010 20:16 schrieb Vern Hamberg:
Dieter

I'm not so sure that is correct. IBM has some federation support
(WebSphere Federation Server, formerly known as DB2 Data Integrator or
WebSphere Information Integrator) that lets you define "connections" on
a PC server to different RDBMS' and let you treat them all as DB2
resources on that server. I believe SQL Server has something similar
(linked servers?).

Now if you do not take advantage of this kind of support, then, yes, you
have to make separate connections. It is the same with our RPG2SQL
Integrator product, although you are able to have multiple live
connections at one time in that product. You are not able to use the
separate connections to join tables, of course.

By the way, is your software free, or are you selling it? It isn't clear
from your posts. Your DRDA support is quite intriguing, of course.

Vern

On 9/9/2010 12:37 PM, Dieter Bender wrote:
Hi Eric,

you can't use two connections in one SQL Statement, regardless which
method you would use.
It works like it works on AS/400, you make a connect to your MS_SQL_DB
(configured with ADDDRDBDIRE and 2 lines in the global.properties),
preparing and opening your cursor to fetch data from the MS_SQL_DB and
then fetching one record into your Host Variables (might be a
DataStructure) then switching the connection to your local database with
set connection, updating your local table (or whatever your want)
switching back to remote with set connection and so on...

You might have multiple Connections to diffrent locations (even Mix with
DRDA Connections) at the same time and switching from one to the other.

If You have further questions, it would be no problem to provide an
example doing this.

ArdGate is work in progress and there will come up manuals later on,
first priority at the moment is marketing, the more users it has the
faster it will grow in functionality, second priority is to complete
functionality for Milestone 4 (select into, positioned uopdate operations
and completing to support all SQL statements). Milestone 5 will provide
commitment controll.

regards

Dieter


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.