Re: Stored Procedures

[shahar mor <shahar_mor@xxxxxxxxx>]

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

1. Pure SQL procedure are easy, However c compiler is mandatory and
also sql development kit 

2. Red book advanced topics in db2/400 contains detailed examples for
this. 

3. In case of any problems email me and i'll send you back some working
code.

Have fun.

shahar_mor@yahoo.com
===


Shahar mor
consultant
YUVAL INFORMATION SYSTEM
herzelia - israel

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.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
+---