Advanced Db2 Application Programming

PT5601
Summary
The student learns advanced programming techniques for accessing Db2 data, and acquires skills in assessing the performance of SQL statements.
Prerequisites
Before taking this course, students should be skilled in coding basic SQL statements, and in embedding these statements in application programs.
Duration
10 Days/Lecture & Lab
Audience
This course is designed for application programmers who need to be able to employ advanced tools to access Db2 data.
Topics
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

Related Scheduled Courses