Beginning DB2: From Novice to Professional

Chapter 8. Developing Functions and Stored Procedures in DB2

You might have heard horror stories about the complexities of building stored procedures and functions, involving the need for arcane compiler configuration, mastery of long-forgotten notions of computer architecture, and understanding millions of inscrutable commands. The reality is that procedural logic in DB2 is a snap, and the real challenge will be to avoid solving every problem with a procedure or function.

I'll cover the basic syntax, calling semantics, management, and administration of stored procedures and functions so you'll have a firm ground on which to learn more. Entire books have been written on those individual aspects, and the DB2 website and online documentation host ...