Informix DataBlade API Programmer's Manual DataBlade API Function Descriptions

The mi_funcarg_get_tabid() returns the table identifier for the column associated with the expensive-UDR argument of a cost or selectivity function.

mi_integer mi_funcarg_get_tabid(funcarg_ptr)

MI_FUNCARG *funcarg_ptr;

funcarg_ptr

is a pointer to the MI_FUNCARG structure that describes the expensive-UDR argument.

Valid in Client LIBMI Application?	Valid in User-Defined Routine?
No	Yes

The mi_funcarg_get_tabid() function returns the table identifier of the argument from the MI_FUNCARG structure that funcarg_ptr references. The MI_FUNCARG structure describes an argument of an expensive UDR to its cost or selectivity function. The table identifier is the value from the tabid column of the systables system catalog table. Use the mi_funcarg_get_tabid() function only for expensive-UDR arguments that are column values; that is, only arguments for which the mi_funcarg_get_argtype() function returns the MI_FUNCARG_COLUMN value.

Use the mi_funcarg_get_tabid() function in a cost or selectivity function to obtain the table identifier for the column with which an argument passed into the expensive UDR is associated.

See the descriptions of the following functions: mi_funcarg_get_argtype(), mi_funcarg_get_colno(), mi_funcarg_get_constant(), mi_funcarg_get_datalen(), mi_funcarg_get_datatype(), mi_funcarg_get_distrib(), mi_funcarg_get_routine_id(), mi_funcarg_get_routine_name(), and mi_funcarg_isnull().

For more information, see Creating Selectivity and Cost Functions.