Re: RPG - MsSQL Connection

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

 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