RE: Where/what is a good reference to learn how to access JDBC fromRPGLE?

Rob,

Another link is: http://www.mcpressonline.com/mc?1@xxxxxxxxxxxxxxxxx@.6b24d1dc

It uses the Oracle JDBC driver as an example, but this should apply for SQL 
Server as well.

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 16-6-05 at 14:56 rob@xxxxxxxxx wrote:

>Thank you.
>
>Rob Berendt
>-- 
>Group Dekko Services, LLC
>Dept 01.073
>PO Box 2000
>Dock 108
>6928N 400E
>Kendallville, IN 46755
>http://www.dekko.com
>
>
>
>
>
>"Wilt, Charles" <CWilt@xxxxxxxxxxxx> 
>Sent by: rpg400-l-bounces@xxxxxxxxxxxx
>06/16/2005 02:20 PM
>Please respond to
>RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
>
>
>To
>"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
>cc
>
>Subject
>RE: Where/what is a good reference to learn how to access JDBC  fromRPGLE?
>
>
>
>
>
>
>Rob,
>
>This is an interesting article that uses a table UDF around the JDBC 
>interface:
>http://www.mcpressonline.com/mc?50@xxxxxxxxxxxxxxx@.6aea26b5
>
>Here's one that uses data queues:
>http://www.iseriesnetwork.com/artarchive/index.cfm?fuseaction=viewarticle&CO_ContentID=19189&channel=&subart=
>
>
>
>HTH,
>
>
>Charles Wilt
>--
>iSeries Systems Administrator / Developer
>Mitsubishi Electric Automotive America
>ph: 513-573-4343
>fax: 513-398-1121
> 
>
>> -----Original Message-----
>> From: rpg400-l-bounces@xxxxxxxxxxxx
>> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
>> Sent: Thursday, June 16, 2005 3:03 PM
>> To: rpg400-l@xxxxxxxxxxxx
>> Subject: Where/what is a good reference to learn how to access JDBC
>> fromRPGLE?
>> 
>> 
>> Will anyone please help answer the following faq:
>> http://faq.midrange.com/data/cache/539.html
>> Where/what is a good reference to learn how to access JDBC from RPGLE?
>> I have a RPG developer that needs to access MS SQL Server 
>> data.  Having 
>> totally gagged on the price of IBM's suggested solution, and 
>> not really 
>> having a whole lot of luck with one third party solution, and 
>> REALLY not 
>> liking the idea of putting software on each SQL server we 
>> want to access, 
>> we decided to evaluate using RPGLE to call JDBC to get to the 
>> data.  How 
>> best to learn how to do this?  This developer supposedly took 
>> a brief java 
>> course.
>> 
>> Also any suggested reference materials?  Perhaps the following:
>> 
>> JDBC and Record Level Access with IBM AS/400 Toolbox for Java
>> by Joe Pluta
>> Book sounds pricy, but it's supposed to more of a course than 
>> a book.  The 
>> second url explains that better (but doesn't give the discount or the 
>> kickback to this wonderful list).
>> http://store.midrange.com/details.php?ASIN=0976269201
>> http://www.lab400.com/product_detail.asp?prod_id=200
>> 
>> Java for RPG Programmers
>> by Phil Coulthard, George Farr
>> http://store.midrange.com/details.php?ASIN=1889671231
>> 
>> iSeries and AS/400 Java at Work (At Work series)
>> by Don Denoncourt
>> http://store.midrange.com/details.php?ASIN=1583470182
>> 
>> Java Application Strategies for iSeries and AS/400--Second Edition
>> by Don Denoncourt
>> http://store.midrange.com/details.php?ASIN=1583470255
>> 
>> Java and the AS/400, Second Edition: Practical Examples for 
>> the iSeries & 
>> AS/400
>> by Daniel Darnell
>> http://store.midrange.com/details.php?ASIN=1583040935
>> 
>> 
>> 
>> Rob Berendt
>> -- 
>> Group Dekko Services, LLC
>> Dept 01.073
>> PO Box 2000
>> Dock 108
>> 6928N 400E
>> Kendallville, IN 46755
>> http://www.dekko.com
>> 
>> -- 
>> This is the RPG programming on the AS400 / iSeries (RPG400-L) 
>> mailing list
>> To post a message email: RPG400-L@xxxxxxxxxxxx
>> To subscribe, unsubscribe, or change list options,
>> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
>> or email: RPG400-L-request@xxxxxxxxxxxx
>> Before posting, please take a moment to review the archives
>> at http://archive.midrange.com/rpg400-l.
>> 
>> 
>
>-- 
>This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
>To post a message email: RPG400-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
>or email: RPG400-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/rpg400-l.
>
>
>-- 
>This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
>To post a message email: RPG400-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
>or email: RPG400-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/rpg400-l.