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. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ 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 HCL OneDB™.
Creating extensionsYou 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 GuideThe 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™.
Create an opaque data type
Other operations on opaque data types
Access an opaque data type

Access an opaque data type

After you create the opaque data type, the following client programs can use it once they connect to the database in which it is registered:

application that uses SQL statements and an lvarchar, fixed binary, or var binary host variable
For more information, see the chapter on opaque types in the HCL OneDB™ ESQL/C Programmer's Manual.
A C routine that uses the DataBlade® API
For more information, see the HCL OneDB DataBlade API Programmer's Guide.
An SPL UDR
For more information, see the topics on SPL in the HCL OneDB Guide to SQL: Tutorial.
A client application written in the Java™ language
To write Java routines, you must have J/Foundation. You also need a Java development kit to compile your Java routines. For information about how to write Java UDRs, refer to the HCL® J/Foundation Developer's Guide.

You can use an opaque data type in any way that you use other data types of the database.