Extend data type support
HCL
OneDB™ provides
support for the following kinds of UDRs.
| UDR task | SPL routines | C routines | Java™ routines | For more information |
|---|---|---|---|---|
| Cast function | Yes | Yes | Yes | Create user-defined casts |
| Cost function | No | Yes | No | Improve UDR performance |
| End-user routine | Yes | Yes | Yes | Create an end-user routine |
| Iterator function | No | Yes | Yes | Develop a user-defined routine |
| Negator function | Yes | Yes | Yes | Improve UDR performance |
| Opaque data type support function | No | Yes | Yes | Create an opaque data type |
| Operator function | Yes | Yes | Yes | Extend operators and built-in functions |
| Operator-class function | No | Yes | No | Extend an operator class |
| Parallelizable UDR | No | Yes | Yes | Improve UDR performance |
| Statistics function | No | Yes | Yes | Improve UDR performance |
| Selectivity function | No | Yes | No | Improve UDR performance |
| User-defined aggregate | Yes | Yes | Yes (with some limitations) | Create user-defined aggregates |
Tip: When you want to perform an iteration in
SPL, use the WITH RESUME keywords.
To extend the support for one of these kinds of functions, you can write your own version of the appropriate function and register it with the database.