Home | Previous Page | Next Page Database Access >

Executing User-Defined Routines

In This Chapter

Accessing MI_FPARAM Routine-State Information

Checking Routine Arguments

Determining the Data Type of UDR Arguments

Handling NULL Arguments with MI_FPARAM

Accessing Return-Value Information

Determining the Data Type of UDR Return Values

Returning a NULL Value

Saving a User State

Obtaining Other Routine Information

Calling UDRs Within a DataBlade API Module

Invoking a UDR Through an SQL Statement

Calling a UDR Directly (Server)

Named Parameters and UDRs

Calling UDRs with the Fastpath Interface

Obtaining a Function Descriptor

Looking Up UDRs

Looking Up Cast Functions

Obtaining Information from a Function Descriptor

Obtaining the MI_FPARAM Structure

Obtaining a Routine Identifier

Determining If a UDR Handles NULL Arguments

Checking for a Variant Function

Checking for a Negator Function

Checking for a Commutator Function

Executing the Routine

Passing in Argument Values

Receiving the Return Value

Sample mi_routine_exec( ) Calls

Executing a Built-in Cast Function

Reusing a Function Descriptor

Using a User-Allocated MI_FPARAM Structure

Creating a User-Allocated MI_FPARAM Structure

Using a User-Allocated MI_FPARAM Structure (Server)

Passing a User-Allocated MI_FPARAM Structure

Freeing a User-Allocated MI_FPARAM

Releasing Routine Resources

Obtaining Trigger Execution Information and HDR Database Server Status

Trigger Information

HDR Status Information

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