Home | Previous Page | Next Page

Developing a User-Defined Routine

In This Chapter

Planning the Routine

Naming the Routine

Defining Routine Parameters

Number of Arguments

Declaring Routine Parameters

Returning Values

Returning a Variant or Nonvariant Value

Using OUT Parameters and Statement-Local Variables (SLVs)

Using INOUT Parameters

Naming Return Parameters

Using an Iterator Function

Creating an Iterator Function

Registering an Iterator Function

Invoking an Iterator Function

Using an Iterator Function in the FROM Clause of a SELECT Statement

Adhering to Coding Standards

Writing the Routine

Registering a User-Defined Routine

Setting Privileges for a Routine

Database-Level Privilege

Language-Level Privilege

Routine-Level Privilege

Creating an SPL Routine

Creating an External-Language Routine

Registering a Routine Written in C

Registering a Routine Written in Java

Registering an External Routine with Modifiers

Registering Parameters and a Return Value

Reviewing Information about User-Defined Routines

Using a UDR With HDR

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