RE: Getting data from a windows database in rpg

Beppe,
Very True and I would suggest it for anyone with a single table or a few
tables to retrieve. If you have the time and expertise or don't have money
to spend on a utility, this is a great way to go. 
We wrote our utility for a client who has many SQL servers that may change
on a daily basis, the databases and tables change frequently and the
selection criteria changes rapidly. They don't  have Java skills or a system
that runs Java fast enough to make it worth while for them.
We started with the Java interface. It just didn't fit what we were
attempting to do.

John Brandt
iStudio400.com
(903) 523-0708

-----Original Message-----
From: Beppe Costagliola [mailto:beppecosta@xxxxxxxx]
Sent: Wednesday, May 19, 2004 2:04 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Getting data from a windows database in rpg


You can use a SQL UDTF. Check mcpressonline for an example.

It works fine and fast, it is not that hard to customize and . . .
everything is FREE.

We have tried it with Microsoft Jdbc and opensource JTDS.

Beppe.

----- Original Message ----- 
From: "Jeffrey Lee" <jeff@xxxxxxxxxxxxxxxxxxx>
To: <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, May 18, 2004 8:07 PM
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.688 / Virus Database: 449 - Release Date: 5/18/04