Hello Sam, 
If you're open to commercial solutions, our RPG2SQL Integrator software
can be used to run stored procedures and access SQL Server databases
from the System I via RPG or COBOL. 
For more info and a free demo, check out our web site or feel free to
contact me directly. 
Regards,
Richard Schoen
RJS Software Systems Inc. 
"Get the information you need. Now!"
Email: richard@xxxxxxxxxxxxxxx
Web Site: 
http://www.rjssoftware.com
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT
------------------------------
message: 5
date: Mon, 28 Apr 2008 09:33:50 -0500
from: "sjl" <sjl_abc@xxxxxxxxxxx>
subject: Calling a SQL Server 2000 stored procedure from a System i
	program
All -
I have the need to call a sql server stored procedure which returns a 
'next-number' value that I need to use in a System I program.  I'm not
sure 
which language I'll be using, so I'm posting here until David redirects
me 
to another list.
I'm guessing I'll need to write a Java program that uses JDBC...
- sjl
As an Amazon Associate we earn from qualifying purchases.