Home | Previous Page | Next Page   Creating User-Defined Routines >

Developing a User-Defined Routine

In This Chapter
Designing a UDR
Development Tools
Uses of a C UDR
Portability
DataBlade API Data Types
Data Conversion
Insert and Update Operations
Creating UDR Code
Variable Declaration
Session Management
Session Restrictions
Transaction Management
SQL Statement Execution
Setting Input Parameters
Retrieving Column Values
Routine-State Information
Event Handling
Well-Behaved Routines
Compiling a C UDR
Compiling Options
Creating a Shared-Object File
Registering a C UDR
EXTEND Role Required to Register a C UDR
The External Name
Specifying the Entry Point
Using Environment Variables
The UDR Language
Routine Modifiers
Parameters and Return Values
Privileges for the UDR
Executing a UDR
Routine Resolution
The Routine Manager
Loading a Shared-Object File
Creating the Routine Sequence
Pushing Arguments Onto the Stack
Managing UDR Execution
Returning the Value
Releasing the Routine Sequence
Debugging a UDR
Using a Debugger
Creating a Debugging Version
Connecting to the Database Server from a Client
Loading the Shared-Object File for Debugging
Identifying the VP Process
Running a Debugging Session
Breakpoints
Debugging Hints
Possible Memory Errors
Symbols in Shared-Object Files
Using Tracing
Adding a Tracepoint in Code
Using Tracing at Runtime
Understanding Tracing Output
Changing a UDR
Altering a Routine
Unloading a Shared-Object File
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]