- DB2 access strategies
- EXPLAIN, PLAN_TABLE, and DSN_STATEMNT_TABLE
- TRUNCATE, GET_DIAGNOSTICS, MERGE, SELECT from DML statements
- OLAP functions
- Joins, left, right, and full
- Subqueries
- UNION, INTERSECT, and EXCEPT
- Nested table expressions
- Common table expressions
- Views
- Application plans and packages
- Remote Data Access
- LOAD and UNLOAD utilities
- DSNTEP2, DSNTIAUL, and DSNTIAD
- Working with LOBs
- External stored procedures
- User-defined data types
- User-defined functions (scalar and table)
- Dynamic SQL
- Call Attachment and Recoverable Resource Services Attachment Facilities
- The ODBC Interface
- REXX and DB2
- Native SQL stored procedures and user defined functions
- XML and DB2
- Locking and performance considerations
- Extended indicator variables
Comments are closed.