Skip to main content

Course description: IBM Informix Stored Procedures and Triggers

This course is not scheduled. Inquire about Onsite training at your facility.

Overview

List of course details in a data table
Course code FN335 Skill level Basic
Duration 2.0 days Delivery type Classroom
(Hands-on labs)
Course type Public only    
Public price USD $1,300.00 plus tax  

Learn how to use and incorporate triggers and stored procedures into your IBM Informix databases and create and execute stored procedures.

See Remarks for Special Note.

View this course in other countries


Training Paths that reference this course are:

Back to top

Special note

IBM Education Advantage Program eligibility:

  • Yes - IBM Education Pack - online account

Back to top

Audience

This is a basic course for application developers, database and system administrators, and technical support individuals.

Back to top

Prerequisites

You should complete:

  • Relational Database Design (CF180)
  • IBM Informix Structured Query Language (FN613)
  • or have equivalent knowledge

You should also have programming experience.

Back to top

Skills taught

  • 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

Back to top

Course outline

  • Introduction to stored procedures
  • Creating and executing stored procedures
  • Stored procedure language statements
  • Exception processing for stored procedures
  • Production environment for stored procedures
  • Creating and using triggers
  • Stored procedure code example

Back to top

Remarks

Special Note for IBM Business Partners authorized to remarket public classes and on-site classes: This course is excluded from the IBM Training Services for Enterprise - on-site Education Program for IBM Business Partners.

Back to top

My IBM

We're here to help

Easy ways to get the answers you need.

or call us at
Call 1-800-426-8322

Open M-F 9AM-7PM ET.

Student center

Find the right course

Offers and more