RE: Calling a java stored procedure from SQL server

["Dan Kimmel" <dkimmel@xxxxxxxxxxxxxxx>]

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.