Re: Calling a java stored procedure from SQL server

[Pete Helgren <Pete@xxxxxxxxxx>]

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