|
The mi_fp_setargisnull() accessor function sets the value of an argument of a user-defined routine to an SQL NULL in its associated MI_FPARAM structure.
The mi_fp_setargisnull() function sets the routine argument at position arg_pos in the MI_FPARAM structure that fparam_ptr references to the appropriate SQL NULL value. The MI_FPARAM structure stores information about whether routine arguments are NULL in the zero-based null-argument array. To set the nth argument, use an arg_pos value of n-1. For example, the following call to mi_fp_setargisnull() sets to NULL the third argument of the my_func() UDR, with which fparam1 is associated:
You can specify the following values for the is_null argument.
Value of is_null | Meaning |
---|---|
MI_FALSE | The argument that arg_pos identifies is not NULL. |
MI_TRUE | The argument that arg_pos identifies is NULL. |
None.
See the descriptions of the following functions: mi_fp_argisnull(), mi_fp_setarglen(), mi_fp_setargprec(), mi_fp_setargscale(), mi_fp_setargtype(), mi_fp_returnisnull(), and mi_fp_setreturnisnull().