Overview of native SQL stored procedures
Defining native SQL stored procedures

• CREATE PROCEDURE
• Parameter declarations
• Options

Removing stored procedure definitions
DROP PROCEDURE

• Computer Exercise:  A Simple native SQL stored procedure

Native SQL Procedures Language Syntax
SQL statements
Compound Statements
Comments
Labels
Declarations: Variable, Conditions, Handlers, and Cursors
Procedural Statements

• Computer Exercise:  A more complicated native SQL stored procedure

ALTER PROCEDURE parameters
Versioning

• ADD VERSION
• ALTER VERSION
• REPLACE VERSION
• ACTIVATE VERSION
• REGENERATE VERSION
• DROP VERSION
• Computer Exercise:  Converting a COBOL stored procedure to native SQL

DB2 Commands for native SQL stored procedures
Deploying native SQL stored procedures
Catalog changes for native SQL stored procedures