COURSE SEARCH
 
   HOME > COURSES > INFORMIX STORED PROCEDURES AND TRIGGERS MEMBERS LOGIN 
UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW
  HOME     COURSE LIBRARY     QUESTIONS & ANSWERS     CONTACT US
There are many excellent online courses. This has been hugely beneficial in my day to day work.
- Louise Nolan


Informix Stored Procedures and Triggers




Course Aims
This course aims to take users through the Informix language. Users will gain an appreciation of privileges, trigger creation, system tables, error handling, ESQL/C and other advanced Informix functions.

This course can be found in the following categories:
Courses > Databases > Informix

Table of Contents
Introduction
  		• The Stored Procedure
  		• The Advantages of Using Stored Procedures
     
    Creating a Stored Procedure
  		• The CREATE PROCEDURE Statement
  		• The Parameter List
  		• The RETURNING Statement
  		• The DEFINE Statements
  		• SQL and SPL Statements
  		• The DOCUMENT Clause
  		• The WITH LISTING IN Clause
  		• Commenting Stored Procedures
  		• An Example of a Stored Procedure
  		• Creating a Stored Procedure Using dbaccess
  		• Creating a Stored Procedure Using an Embedded SQL Product
  		• Creating a Stored Procedure
     
    Using a Stored Procedure
  		• Executing a Stored Procedure
  		• Obtaining the Text of a Stored Procedure
  		• Dropping a Stored Procedure
  		• Using a Stored Procedure
     
    The SELECT Statement
  		• The Syntax of the SELECT Statement
  		• Rows Returned by a SELECT Statement
  		• The FOREACH Statement
  		• The RETURN Statement
  		• The Select Statement
     
    The Stored Procedure Language
  		• The LET Statement
  		• The IF Statement
  		• The WHILE Statement
  		• The FOR Statement
  		• The EXIT Statement
  		• The CONTINUE Statement
  		• The SYSTEM Statement
  		• The BEGIN . . . END Blocks
     
    Variables
  		• The Use of Variables
  		• The Format of Variables
  		• Global and Local Variables
  		• The Data Types for Variables
  		• The Scope of Variables
  		• Variable/Keyword Ambiguity
  		• Variables and Column Names
  		• Variables and SQL Functions
    Privileges on Stored Procedures
  		• Procedure Privilege Types
  		• Privileges at Creation
  		• Privileges at Execution
  		• Granting and Revoking Privileges on Stored Procedures
  		• Privileges and Owner-Privileged Procedures
  		• Privileges and DBA-Privileged Procedures
  		• Privileges and Nested Procedures
     
    Error Handling and Debugging
  		• Exception Handling
  		• The Scope of the ON EXCEPTION Statement
  		• Raising an Exception
  		• Debug Tracing
  		• The SET DEBUG Statement
     
    Stored Procedure System Tables
  		• sysprocauth
     
  		• sysprocbody
  		• sysprocedures
  		• sysprocplan
     
    Trigger Actions
  		• Preface
  		• Introduction
  		• Trigger Creation Products
     
    The Types of Trigger
  		• Insert Triggers
  		• Delete Triggers
  		• Update Triggers
  		• The Use of REFERENCING Prefixes
  		• Consistency
  		• Dropping a Trigger
  		• The Types of Trigger
     
    Trigger Considerations
  		• Privileges to Execute Triggered Actions
  		• Cascading Triggers
  		• Constraint Checking
  		• Preventing Triggers from Overriding Each Other
  		• Logging and Recovery
  		• Triggers and Other SQL Statements
  		• Using Stored Procedures in Triggers
     
    Trigger System Tables
  		• systrigbody
  		• systriggers
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Monday 21st May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft