Extending Informix Dynamic Server 2000 Developing a User-Defined Routine

In This Chapter

Planning the Routine

Naming the Routine

Defining Routine Parameters

Number of Arguments

Declaring Routine Parameters

Returning a Value

Returning a Variant or Nonvariant Value

Returning Multiple Values with an OUT Parameter

Returning Values with an Iterator Function

Adhering to Coding Standards

Writing the Routine

Creating a Shared-Object File

Registering a User-Defined Routine

Setting Privileges for a Routine

Database-Level Privilege

Language-Level Privilege

Routine-Level Privilege

Registering an SPL Routine

Registering an External Routine

Registering an External Function

Registering an External Procedure

Registering an External Routine with Modifiers

Registering Parameters and a Return Value

Reviewing Information about User-Defined Routines