RE: Getting data from a windows database in rpg

Yes,
We have done it, but it doesn't use JDBC drivers. It is a purely native set
of API's and commands that allow direct access both directions including a
trigger subsystem to synchronize from AS/400-iSeries to and from MSSQL
server. It also includes commands for non-programmer types to perform simple
gets, puts and deletes.

John Brandt
iStudio400.com


-----Original Message-----
From: DeLong, Eric [mailto:EDeLong@xxxxxxxxxxxxxxx]
Sent: Tuesday, May 18, 2004 2:18 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: Getting data from a windows database in rpg


John Brandt has done this via JDBC type 3 drivers, I think....  Your choices
are limited for roll-your-own options.  Some commercial products (IBMs
Datajoiner is one product, I think) could help, but you gotta license that
stuff.  

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Jeffrey Lee [mailto:jeff@xxxxxxxxxxxxxxxxxxx]
Sent: Tuesday, May 18, 2004 1:08 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Getting data from a windows database in rpg


I need to get data from an SQL database on Windows NT through an RPG program
on the AS/400. Does anyone know how this is done?

Thanks,
Jeff
_______________________________________________
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.

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.665 / Virus Database: 428 - Release Date: 4/21/04
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 5/16/04