Chapter 9. Development SQL
• 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. SYNONYM, ALIAS, COMMIT, and 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.
User-Defined ...
Get DB2® 9 for Linux®, UNIX®, and Windows®: DBA Guide, Reference, and Exam Prep, Sixth Edition 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.
