RE: Calling a java stored procedure from SQL server

Pete,

This SHOULD be fairly simple. MSSQL Server is a DRDA host and you can
mount the DB2400 database as a remote database.

I'm pretty sure DRDA supports stored procedures.

Create the stored procedure as a java stored procedure in your DB2400
database. Then just EXEC the stored procedure on the DB2400 remote
database.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Helgren
Sent: Thursday, April 02, 2009 3:07 PM
To: Midrange Systems Technical Discussion
Subject: Re: Calling a java stored procedure from SQL server

The issue is the call. I haven't seen an example of SQL Server calling
anything but a "regular" stored procedure using exec. With DB2 I can
just issue a "Call mylibrary/myprogram" through SQL and the program is
invoked. I don't see how I can issue the same thing in SQL Server since
the the SQL server is on a different machine.

Maybe REXX? The issue is how to get SQL Server to run something in the
OS, not in the DB.

Pete


BMay@xxxxxxxxx wrote:

You said you have called it from RPG. So make yourself a little RPG
wrapper. I think you can make the RPG program accessible from a
stored procedure or maybe a web service (don't know if SQL Server can
call a web service though)

HTH,

Brian May
Project Lead
Management Information Systems
Garan, Incorporated
Starkville, Mississippi

Young i Professionals
http://www.youngiprofessionals.com



Pete Helgren <Pete@xxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/02/2009 02:31 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> cc

Subject
Calling a java stored procedure from SQL server






OK. This isn't directly an i question but the i stands for
"integration" so I'll give it a whirl.

I have a java application that is fairly complex and produces an
output file on the i. I have called it from RPG and from DB2 but I
need to call the same java app from MS SQL Server (2000) that is
residing on the same network. So far the only thing I have been able
to come up with is to write an extended stored procedure in C that
would invoke the Java app [maybe] (PLEASE don't make me do it!).

So, I know there are some folks on the list that have to integrate MS
SQL Server with their i shops. Is there any way to do this? Seems I
need to wrap something around the Java app so that SQL Server 2000 can

call it but what?

Pete

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.