Jump to main content
Product Documentation
Customer Support
HCL OneDB V1.0.0.0
Getting Started
Product overview
Installing
Administering
Security
Client APIs and tools
SQL programming
JSON compatibility
Extending
HCL OneDB™
Designing databases
Embedding
HCL OneDB™
Release information
Search
Home
Extending
HCL OneDB™
Beyond standard relational database objects,
HCL OneDB™
can be extended to handle specialized data types, access methods, routines, and other objects. Informix® includes many built-in extensions that are fully integrated in the database server. Informix® also provides
DataBlade®
modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for Informix®.
Creating extensions
You can create user-defined data types, routines, access methods, and other database objects to suit your needs. You can use application programming interfaces to write user-defined routines and applications that access data in
HCL OneDB™
databases.
User-Defined Routines and Data Types Developer's Guide
These topics describe how to define new data types and enable user-defined routines (UDRs) to extend
HCL OneDB™
.
The
HCL OneDB™ User-Defined Routines and Data Types Developer's Guide
describes how to define new data types and enable user-defined routines (UDRs) to extend
HCL OneDB™
.
Run a user-defined routine
Extending
HCL OneDB™
Beyond standard relational database objects,
HCL OneDB™
can be extended to handle specialized data types, access methods, routines, and other objects. Informix® includes many built-in extensions that are fully integrated in the database server. Informix® also provides
DataBlade®
modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for Informix®.
HCL OneDB™
extensions and
DataBlade®
modules
These topics describe how to use built-in database extensions and separately installed
DataBlade®
modules.
Creating extensions
You can create user-defined data types, routines, access methods, and other database objects to suit your needs. You can use application programming interfaces to write user-defined routines and applications that access data in
HCL OneDB™
databases.
DataBlade® API
Function Reference
These topics describe the
DataBlade® API
functions and the subset of
HCL OneDB™ ESQL/C
functions that the
DataBlade® API
supports.
The
HCL OneDB™ DataBlade® API Function Reference
describes the
DataBlade® API
functions and the subset of
HCL OneDB™ ESQL/C
functions that the
DataBlade® API
supports.
DataBlade®
Developers Kit
The
DataBlade®
Developers Kit (DBDK) guides contain information about the tools you can use to develop and package
DataBlade®
modules, which extend the functionality of
HCL OneDB™
databases.
J/Foundation Developer’s Guide
User-Defined Routines and Data Types Developer's Guide
These topics describe how to define new data types and enable user-defined routines (UDRs) to extend
HCL OneDB™
.
The
HCL OneDB™ User-Defined Routines and Data Types Developer's Guide
describes how to define new data types and enable user-defined routines (UDRs) to extend
HCL OneDB™
.
Extend the database server
A user-defined routine
Run a user-defined routine
Invoke a UDR in an SQL statement
Invoke a UDR in an SPL routine
Execute a user-defined routine
Understanding routine resolution
Develop a user-defined routine
Extend data types
Extend operators and built-in functions
Create user-defined casts
Create user-defined aggregates
Create an opaque data type
Write support functions
Extend an operator class
Manage a user-defined routine
Improve UDR performance
Run a user-defined routine
Invoke a UDR in an SQL statement
Invoke a UDR in an SPL routine
Execute a user-defined routine
Understanding routine resolution