The mi_func_handlesnulls() function

The mi_func_handlesnulls() function determines whether a user-defined routine (UDR) can handle SQL NULL values.

Syntax

mi_integer mi_func_handlesnulls(funcdesc_ptr)
   MI_FUNC_DESC *funcdesc_ptr;
funcdesc_ptr
A pointer to a function descriptor for a UDR.
Valid in client LIBMI application? Valid in user-defined routine?
No Yes

Usage

The mi_func_handlesnulls() function determines whether the UDR associated with the funcdesc_ptr function descriptor handles SQL NULL values as arguments. You can register a UDR that handles NULL arguments with the HANDLESNULLS routine modifier of the CREATE FUNCTION or CREATE PROCEDURE statement.

The mi_func_handlesnulls() function is one of the functions of the Fastpath interface.

Return values

1
The UDR that the funcdesc_ptr function descriptor identifies can handle NULL values.
2
The UDR that the funcdesc_ptr function descriptor identifies cannot handle NULL values.
MI_ERROR
The function was not successful.