O'Reilly logo

SQL Procedures, Triggers, and Functions on IBM DB2 for i by Simona Pacchiarini, Tom Mckinley, Doug Mack, Jim Denton, Dan Cruikshank, Mike Cain, Rob Bestgen, Hernando Bedoya, Jim Bainbridge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating flexible and reusable procedures
A reusable procedure can be called from multiple procedures. A flexible procedure can be reused and it accepts different inputs and produces output based on that input. Dynamic Structured Query Language (SQL) falls within this definition. But what about the procedures that take advantage of dynamic SQL? How can they be written so that they easily adapt to the ever-changing needs of the business?
This chapter provides the answers to those questions and more. It includes the following topics:

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required