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.
J/Foundation Developer's GuideThe HCL® J/Foundation Developer's Guide describes how to write user-defined routines (UDRs) in the Java™ programming language for HCL OneDB™.
Create Java™ user-defined routinesA user-defined routine (UDR) is a routine that an SQL statement or another UDR can invoke. UDRs written in Java™ code use the server-side implementation of the HCL OneDB™ JDBC Driver to communicate with the database server.
Packages for Java™ user-defined routinesVarious packages can be used to create Java™ user-defined routines (UDRs).

Packages for Java user-defined routines

Various packages can be used to create Java™ user-defined routines (UDRs).

UDRs can use all the basic nongraphic Java packages that are in the software development kit for Java.

UDRs must use the server-side HCL OneDB™ JDBC Driver to access the database. The server-side driver is shipped in a JAR file that is in $INFORMIXDIR/extend/krakatoa/jdbc.jar. UDRs can use most HCL OneDB extensions to the JDBC specification.

The HCL OneDB extensions are in the com.informix.udr package. Such extensions include logging, tracing, iterator support, and invocation-state management.

See Java technology dependencies.