|
From the beginning, as far as I know. However, it only supports DRDA asa host; it cannot be a client. So you can't ADDRDBDIRE on your i and
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,http://archive.midrange.com/midrange-l.
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
