db2e 所支持的操作

在IBM网站上看到的db2e所支持的操作
（http://www.devx.com/IBMDB2/Article/28552）

• SELECT, INSERT, DELETE, UPDATE
• Subselect statements and JOINs
• CREATE, ALTER, and DROP TABLE
• CREATE and DROP INDEX
• Multiple column indices
• GROUP BY, ORDER BY, LENGTH, RTRIM, IN
• Aggregate functions like MAX, MIN, AVG, SUM, and COUNT
• Scrollable cursors (especially handy for optimal performance in your handheld app)
• Transactional processing with isolation levels UR, CS, RS, and RR
• Table-level encryption
• More JOINs (RIGHT OUTER, LEFT OUTER, INNER)
• HAVING clause
• UNION, UNION ALL
• Triggers
• Stored Procedures
• FOREIGN KEYs and cascading delete
• CREATE and DROP schema
• CREATE and DROP view
• Database-level encryption
• Multiple connections with row-level locking