Extending INFORMIX-Universal Server: User-Defined Routines

Extending INFORMIX-Universal Server: User-Defined Routines
Chapter 1: Overview of User-Defined Routines

Home Contents Index Master Index New Book

Overview of User-Defined Routines

In This Chapter

What Is a User-Defined Routine?

Tasks That You Can Perform with UDRs

Encapsulate Multiple SQL Statements

: Simplify Writing Programs
: Improve Performance of Multiple SQL Statements

Extend Functions for Built-In Data Types

: SQL-Invoked Functions
: Casting Functions
: Operator Class Functions

Support New Data Types

: SQL-Invoked Functions
: Support Functions
: Operator Class Functions
: Casting Functions
: Operator Binding

Use as a Triggered Action

Restrict Access to a Table

Enforce Business Rules

Ways to Invoke User-Defined Routines

Extending INFORMIX-Universal Server: User-Defined Routines, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.