• USER-DEFINED FUNCTIONS
• USER-DEFINED STRUCTURED DATA TYPES
• SYNONYM AND ALIAS
• COMMIT AND ROLLBACK
• SQL PROCEDURAL LANGUAGE
• STORED PROCEDURES
This chapter will cover some of the additional SQL features that are included in DB2 that are primarily intended for developers. User-defined functions (UDFs) and user-defined structured data types can be used for enhancing the functions and data types available in DB2.
ROLLBACK are used within programs for controlling the access to objects and determining changes in the database. Finally, the SQL Procedural Language (SQL PL) is introduced for its use in triggers, user-defined functions, stored procedures, and within SQL blocks.