DB2 UDB Advanced Programming
Course Outline


► Introduction and static review
  • ► identify DB2 family products and explain DB2 workstation component functions
  • ► identify the key differences between static SQL and other application alternatives for accessing DB2 data
  • ► identify requirements to support embedded SQL programs
  • ► use compound SQL
  • ► code CONNECT statements within an application program
  • ► describe considerations when using Distributed Unit of Work (DUOW)
► Stored procedures
  • ► describe when the use of stored procedures is appropriate
  • ► describe DB2's implementation of stored procedures
  • ► list the characteristics and specification requirements of the client application and the server procedure
  • ► describe the communication structures used with stored procedures
  • ► write stored procedures
► Introduction to Call Level Interface (CLI)
  • ► identify the differences between CLI and embedded SQL
  • ► identify the advantages of CLI
  • ► identify the disadvantages of CLI
  • ► define the primary tasks of an application
  • ► describe the purpose of handles
  • ► identify how a transaction is started
  • ► process result sets returned from stored procedures
► Using object-relational capabilities
  • ► describe and use programming options for handling large objects
  • ► describe why a user-defined type may be used
  • ► identify how to define a user-defined type
  • ► describe why a user-defined function may be used
  • ► identify how to register a user-defined function
  • ► Identify how a user-defined function is invoked
  • ► determine which user-defined function will be invoked based on name, function path, and parameter types
  • ► write a user-defined function
► APIs
  • ► describe when the use of APIs is appropriate
  • ► use APIs in application programs
  • ► identify functions provided by APIs
► Daily Agenda - Day 1
  • ► Welcome
  • ► Introduction and static review
  • ► Lab - compound SQL
  • ► Stored procedures
  • ► Lab - stored procedures
  • ► Introduction to CLI
  • ► Lab - introduction to CLI
► Day 2
  • ► Using object-relational capabilities
  • ► Lab - using object-relational capabilities
  • ► APIs
  • ► Lab - APIs