IBM Informix Stored Procedures and Triggers Training  

• Explain what a stored procedure is
• Explain advantages of using stored procedures

Creating and Executing Stored Procedures

• Create a stored procedure
• Execute a stored procedure
• Pass values into a stored procedure
• Return values from a stored procedure

Stored Procedure Language Statements

• Define variables inside a stored procedure
• Assign values to variables and use control blocks
• Use SPL flow control statements

Exception Processing for Stored Procedures

• Handle errors inside a stored procedure
• Use exception processing to move within and between stored procedures
• Use version control with stored procedures

Production Environment for Stored Procedures

• List performance considerations for stored procedures
• Create DBA stored procedures
• Use GRANT and REVOKE to control permissions of stored procedures

Creating and Using Triggers

• List the possible uses for triggers in a database system
• Use the CREATE TRIGGER statement to create a trigger
• Understand the implications of using triggers with transactions, security, and constraints

Stored PROCEDURE Code Example

Agenda

Day 1

• Welcome
• Unit 1: Introduction to stored procedures
• Unit 2: Creating and executing stored procedures
• Exercise 1
• Unit 3: Stored procedure language statements
• Exercise 2

Day 2

• Unit 4: Exception processing for stored procedures
• Exercise 3
• Unit 5: Production environment for stored procedures
• Unit 6: Creating and using triggers
• Exercise 4
• Unit 7: Stored PROCEDURE code example