Re: Stored Procedures

[Terrell Deppe <terrell@xxxxxxxxxx>]

After months of painful research, and misguided marketing information, I finally
got some answers at JavaOne.  Since then I've received the following from an IBM
Rochester developer.  I'm copying (BCC) them on this because I think they might
want your input, and I don't know if they want their e-mail addresses being
tossed around on list servers.  Here's an edited version of one of the messages:

> I am working on the support for Java Stored Procedures for "future" releases 
>of
> OS/400, most likely V4R5 and V5R1.  Nothing has been officially announced, 
>but I
> am working on the support.
> 
> We are currently planning on supporting the DB2GENERAL parameter style, which 
> was defined by DB2 in Version 5.   We are also planning on supporting the JAVA
> parameter style as defined by the emerging SQLJ:SQL Routines standard (see
> http://www.sqlj.org).  
> 
> There is no easy work around for V4R4.  An expensive work around would be to 
> write a 'C' stored procedure that uses the JNI interfaces to start your own 
> JVM and then run your Java stored procedure there.  However, this approach 
> would encounter the limitation that you not be able to use JDBC within the 
> Java stored procedure.

I can't tell you how many times I've been told that you could use Java for SP's
and triggers.  That was one of the primary deciding points to our selection of
an AS/400.  The scariest part of the whole thing was finding out how many AS/400
developers and sales people at IBM (and everywhere else) don't know what a
stored proc or trigger is.

My fingers are crossed for a quick solution.

-Terrell


enord@oriental.com wrote:
> 
> We are currently writing are main system in Java.  We have SQL statements 
>inside
> our class files.  We would like to create pure SQL stored procedures on the 
>400.
> Has anyone created these and could someone please give me an example of the
> code.  I have found a little on IBM's web site, but I don't think it is very
> good.  What should the source type be and what are the steps to compile this.
> 
> Thank you in advance for all you help
> Erik Nord
> Oriental Trading Company
> Omaha, NE
> 
> +---
> | This is the JAVA/400 Mailing List!
> | To submit a new message, send your mail to JAVA400-L@midrange.com.
> | To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---