UDR

The DataBlade API provides functions, called the fastpath interface, to call another UDR.

The Java and C functions can be used in external programs, or directly inside the engine with User Defined Routines (UDRs).

There are limitations on the number of arguments that can be passed to a UDR used by a functional index.

A functional index cannot be created on a UDR that returns a large object.

Advantages and potential applications of the UDR technique were discussed.

A UDR used by a functional index cannot have arguments that are collection data types.

Note, however, that large objects can be passed to the UDR as arguments.

A functional index is created on values returned by a User Defined Routine (UDR).

This tutorial shows you how to compile and run your VTI UDR as a shared library.

You must explicitly specify NOT VARIANT when you define a UDR that is used for a functional index.

Compile the C UDR and create a shared library.

If your server is configured with IFX_EXTEND_ROLE set to ON, then you will need the EXTEND role in order to create the UDRs.

Here the term UDR is used generically to refer to functions that return a value.

For example, as of IDS 9. 4, you can pass up to 102 columns as arguments to a C UDR and up to 341 columns as arguments to a Java or SPL UDR.

Create functional indexes on the functions provided by our C UDR and issue the query again

The UDR is written in C and can process simple color TIFF images. The following functions are provided