Re: RPG - MsSQL Connection

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