DB2 Version 9.7 for Linux, UNIX, and Windows

Designing SQL procedures

About this task

Designing SQL procedures requires an understanding of your requirements, SQL procedure features, how to use the SQL features, and knowledge of any restrictions that might impede your design. The following topics about SQL procedure design will help you learn how to design SQL procedures that make best use of SQL procedure features.
  • Parts of SQL procedures
  • Cross-platform SQL stored procedure considerations
  • Supported SQL PL statements and language features in SQL procedures
  • OLTP considerations for SQL procedures
  • Performance of SQL procedures
  • Rewriting SQL procedures as SQL user-defined functions
  • Handling DB2® errors and warnings
Parent topic: SQL procedures