Advanced DB2 Application Programming
Course Code: G-562
Recommended Duration: 10 Days
The student learns advanced programming techniques for accessing DB2 data,
and acquires skills in assessing the performance of SQL statements.
Application programmers who need to be able to employ advanced tools to
access DB2 data.
The student should be skilled in coding basic SQL statements, and in embedding
these statements in application programs.
Related IBM Materials
Classroom access to a set of DB2 Reference manuals is desirable, but not required.
Major Topics Include
- 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
- UNION, INTERSECT, and EXCEPT
- Nested table expressions
- Common table expressions
- 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
There are 23 machine exercises.