Home | Previous Page | Next Page

Running a User-Defined Routine

In This Chapter

Invoking a UDR in an SQL Statement

Invoking a UDR with an EXECUTE Statement

Invoking a Function

Using a SELECT Statement in a Function Argument

Invoking a Procedure

Invoking a User-Defined Function in an Expression

Invoking a Function That Is Bound to an Operator

Named Parameters and UDRs

Invoking a UDR in an SPL Routine

Executing a User-Defined Routine

Parsing the SQL Statement

Optimizing the SQL Statement

Executing a UDR Across Databases of the Same Database Server Instance

Executing the Routine

Executing an SPL Routine

Executing an External Language Routine

Understanding Routine Resolution

The Routine Signature

Using ANSI and Non-ANSI Routine Signatures

Using the Routine Signature to Perform DBA Tasks

Overloading Routines

Creating Overloaded Routines

Assigning a Specific Routine Name

Specifying Overloaded Routines During Invocation

Overloading Built-In SQL Functions

The Routine-Resolution Process

The Routine Signature

Candidate List of Routines

Precedence List of Data Types

Precedence List for Built-In Data Types

Routine Resolution with User-Defined Data Types

Routine Resolution in a Type Hierarchy

Routine Resolution with Distinct Data Types

Routine Resolution with Built-In Data Types as Source

Routine Resolution with Collection Data Types

Null Arguments in Overloaded Routines

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]