Summary

This chapter has covered some of the SQL enhancements that have been introduced in DB2 UDB v8.1. These enhancements include the following:

  • New functions for monitoring the operational state and health of a database, XML publishing, and date conversions

  • The MERGE command to combine a transaction table with a base table

  • New techniques for sampling data within a SELECT statement

  • Improvements to the UNION ALL command to allow inserts, updates, and deletes across all of the tables in a view

  • An INSTEAD OF trigger for complex view processing

  • IDENTITY and SEQUENCE value support in a partitioned environment

  • ORDER BY and FETCH FIRST enhancements to reduce the amount of data being retrieved during a sort

  • A dynamic CALL statement that makes it more flexible ...

Get DB2® Version 8: The Official Guide 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.

Start your free trial