Chapter 18. Using XML in Stored Procedures, UDFs, and Triggers
Stored procedures, user-defined functions (UDFs), and triggers are database objects that encapsulate processing steps to retrieve or manipulate data in the database. They can contain multiple statements that are invoked and executed as a single unit. They are typically used to implement application-specific logic. Stored procedures and UDFs can be implemented in the SQL Procedure Language (SQL PL) or in external languages such as Java, C, or COBOL. The benefits of stored procedures and UDFs include:
• Reduced coding labor due to the creation of reusable processing modules
• Richer processing capabilities in the databases by defining custom logic and functions
• Improved ...
Get DB2 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.
