RE: Connecting to SQL Server

We use both VARPG with ODBC and this utility PRTVMSF using CL program.

http://www.prosperosoftware.co.uk/software/as400/util400.html



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of vhamberg@xxxxxxxxxxx
Sent: Thursday, May 10, 2007 11:35 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Connecting to SQL Server

Jeff

There is no native iSeries way to do this.

<verndor response>
We have a product called RPG2SQL Integrator that does this barrier down
very well - it's a set of functions in a service program that you use to
communicate with our PC server, which, in turn, relays DB requests in
real-time to any SQL-based database server. 30-day eval fully supported
- glad to give a demo. Check us out at www.rjssoftware.com or call
888.rjs.soft.
</verndor response>

There are other options - JDBC comes to mind, as well as IBM's
Information Integrator (is that it's name now?) The latter also uses a
middleware PC. JDBC can be completely on the iSeries. I think Joe Pluta
wrote something for Rob that uses it to do this kind of thing.

For more info, look up "heterogeneous milligan" or some such in google,
for an article by Kent Milligan.

HTH
Vern
-------------- Original message --------------
From: jeffw@xxxxxxxxxxxxxxxx

Hi everyone. I have project that requires information from a SQL

server back

to the AS/400 in my program. I have never had the need to connect to

an

external server to retreive information back for my programs before.

So my

question is:

What is the best way to connect to the server in my program? I was

leaning

towards using an SQL statement in my CL program. Does anyone have a

sample

of a connection string that I could use as a guide? Or is there a

better

method.

The program logic will be the user will an item number in the AS/400

it will

then merge information from the DB2 and the SQL server and present it

on the

screen or a report.

Any help will be appreciated. Thank you

Jeff Williams


--
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.