Extending INFORMIX-Universal Server: User-Defined Routines
Chapter 1: Overview of User-Defined Routines
Home
Contents
Index
Master Index
New Book
Ways to Invoke User-Defined Routines
You can execute an external procedure and an SPL procedure using the
EXECUTE PROCEDURE
statement from the following:
SPL
DB
-Access
ESQL/C
You cannot use a procedure in an SQL expression because a procedure does not return a value.
You can execute an external function and an SPL function from the following:
SPL
DB
-Access
ESQL/C
by using the
EXECUTE FUNCTION
statement
An SQL expression (in the
SELECT
clause or
WHERE
clause).
The database server can invoke a
UDR
implicitly for two reasons:
Built-in operator binding
Implicit casting
For more information on how to invoke user-defined routines, refer to "Invoking a Routine" on page 4-3.
Extending INFORMIX-Universal Server: User-Defined Routines
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
