DB2 Java Stored Procedures Learning by Example
Stored procedures can provide major benefits in the areas of application performance, code re-use, security, and integrity. The DB2 Family of products has offered support for stored procedures for some time, with each release offering significant enhancements over the last.
In the meantime, Java's inherent portability and openness, combined with the availability of skilled programming resource, has made it an increasingly attractive choice as the central plank in the e-business strategy of many organizations.
Until recently, DB2 did not support stored procedures written in Java, so the advantages of the two technologies could not be combined. The latest releases of DB2 have changed all that, opening up new possibilities for secure, highly portable application development.
This IBM Redbook aims to give the reader an in-depth understanding of the techniques and issues associated with the development of DB2 stored procedures written in SQLJ and JDBC. The extensive collection of sample code presented in this book and included on the accompanying CD-ROM was designed to run against DB2 UDB Server across the OS/390, Windows, and UNIX platforms.
Table of Contents
Part 1. Background
Chapter 1. Java platform support
Chapter 2. Java and DB2
Part 2. Developing Java stored procedures
Chapter 3. Java Sample application: The ACME software company
Chapter 4. System setup
Chapter 5. Designing Java stored procedures
Chapter 6. Coding Java stored procedures
Chapter 7. Preparing Java stored procedures
Chapter 8. Deployment and execution
Chapter 9. Client applications invoking Java stored procedures
Chapter 10. Migration of DB2 for OS/390 Version 5 to Version 6
Part 3. DB2 UDB for OS/390 V6 -- various enhancements
Chapter 11. DB2 UDB for OS/390 network computing enhancements
Chapter 12. DB2 UDB for OS/390 schema support
Chapter 13. DB2 UDB for OS/390 stored procedures enhancements
Part 4. Appendices
Appendix A. New messages and error codes
Appendix B. Sample code, DDL, and preparation scripts
Appendix C. OS/390 Recoverable Resource Services (RRS)
Appendix D. Define WLM stored procedure address space
Appendix E. Using the additional material
SOURCE : http://publib-b.boulder.ibm.com/Redbooks.nsf/9445fa5b416f6e32852569ae006bb65f/742209f135fb0fcc88256877006ab27d?OpenDocument&Highlight=0,udb