Re: IBM i connection to SQL server databases via SQL or RPG

Subject: Re: IBM i connection to SQL server databases via SQL or RPG
From: rob@xxxxxxxxx
Date: Tue, 30 Jun 2009 13:58:34 -0400
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@xxxxxxxxxxxx?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@xxxxxxxxxxxx>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@xxxxxxxxxxxx?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@xxxxxxxxxxxx?subject=unsubscribe>

SQL tends to not like CONNECTing to two different databases at the same
time: be it two different DB2 lpars, DB2 and SQL Server or whatever.

So, on your DB2 side you may wish to use RLA (Record Level Access -
traditional RPG or COBOL I/O). Then that can use JDBC to connect to SQL
Server. Numerous magazine articles illuminating JDBC. We contracted with
Joe Pluta years ago to do some JDBC for us to connect to SQL Server. (We
were a bit swamped at the time.) We stopped using the application when we
sold off the division.

Rob Berendt

This thread ...

IBM i connection to SQL server databases via SQL or RPG , elehti

Re: IBM i connection to SQL server databases via SQL or RPG, rob <=
Re: IBM i connection to SQL server databases via SQL or RPG , Dave
Re: IBM i connection to SQL server databases via SQL or RPG , Vern Hamberg

Re: IBM i connection to SQL server databases via SQL or RPG , Alan Campin
RE: IBM i connection to SQL server databases via SQL or RPG , Mike Cunningham

References:
- IBM i connection to SQL server databases via SQL or RPG , elehti

Prev by Author: STRASPBAL on guested partitions
Next by Author: Re: Domino 8 compression
Previous by thread: IBM i connection to SQL server databases via SQL or RPG
Next by thread: Re: IBM i connection to SQL server databases via SQL or RPG
Index(es):

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2010 by MIDRANGE dot 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 here. If you have questions about this, please contact