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:
Get SQL Procedures, Triggers, and Functions on IBM DB2 for i now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
