G564: Major Topics

  • DB2 stored procedure architecture
  • Stored Procedure Address Spaces
  • Defining stored procedures
  • CREATE PROCEDURE, ALTER PROCEDURE, DROP PROCEDURE
  • Stored procedure catalog tables
  • Writing stored procedures
  • Parameter styles: GENERAL, GENERAL WITH NULLS, and DB2SQL
  • Invoking stored procedures
  • Preparing stored procedures and their invokers for execution
  • DB2 Commands for stored procedures
  • Returning result sets
  • Accessing result sets
  • Dynamic SQL in stored procedures
  • ODBC and stored procedures
  • SQL procedures language
  • Stored procedure builder overview
  • REXX and stored procedures
×

Comments are closed.