O'Reilly logo

DB2 by Pav Kumar-Chatterjee, Matthias Nicola

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

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 ...

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