O'Reilly logo

DB2® 9 for Linux®, UNIX®, and Windows®: DBA Guide, Reference, and Exam Prep, Sixth Edition by Paul C. Zikopoulos, George Baklarz

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

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