#FN-335

Using Stored Procedures and Triggers

Course Description

For application developers and system administrators. Learn how to use and incorporate triggers and stored procedures into your Informix databases. Learn how to create and execute stored procedures using stored procedure language statements. Learn how to create triggers and use triggers to call a stored procedure.

Your New Skills

• Explain advantages of using stored procedures
• Use stored procedure language statements
• Create and execute stored procedures
• Pass and return values from a stored procedure
• Identify uses for triggers in a database system
• Create triggers
• Use triggers to call stored procedures

Who Should Attend: Application developers, database and system administrators, technical support personnel

Prerequisites

• Programming experience
• FN-611 Relational Database Design or equivalent knowledge
• FN-613 Structured Query Language or equivalent knowledge

Length: 2 days

Format: Lecture and hands-on exercises

Course Number: FN-335

Recommended Next Course:

• L1-846 System Administration: Informix Dynamic Server (UNIX)
• L1-763 System Administration: Informix Extended Parallel Server
• L2-849 Managing the Extensible Informix Dynamic Server Database
• L1-007 Developing Applications Using Informix 4GL
• L1-112 Developing Applications Using Informix ESQL/C