Sounds like you just need to create an external Stored Procedure definition
for your java routine. You can find the details in the "Stored Procedures,
Triggers, and User-Defined Functions on DB2 Universal Database for iSeries"
redbook:
http://www.redbooks.ibm.com/abstracts/sg246503.html?Open
Elvis
Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com
-----Original Message-----
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
midrange.com
