The ifx_var_setnull() function

The ifx_var_setnull() function sets an lvarchar or var binary host variable to a null value.

Syntax

var binary 
mint ifx_var_setnull(var_bin, flag)
   var binary **var_bin;
   mint flag
lvarchar 
mint ifx_var_setnull(var_bin, flag)
   var binary **var_bin;
   mint flag;
var_bin
The address of the var binary host variable.
lvar
The address of the lvarchar pointer host variable.
flag
The value 0 to indicate a non-null value or 1 to indicate a null value.

Usage

The ifx_var_setnull() function sets a host variable of type lvarchar or var binary to a null value. To set the host variable of any other data type to null, use the rsetnull() library function.

Return codes

0
The function was successful.
<0
The function was not successful and the return value indicates the cause of the error.