Informix DataBlade API Programmer's Manual DataBlade API Function Descriptions

The mi_value_by_name() function retrieves a column value from a row, given the column name.

mi_integer mi_value_by_name(row, column_name, retbuf, retlen)

MI_ROW *row;

char *column_name;

MI_DATUM *retbuf;

mi_integer *retlen;

row	is the row from which values are being extracted.
column_name	is name of the column for which the value is to be returned.
retbuf	is a pointer to a location in the user space that will be set to the address of a buffer that contains the returned value. The buffer is allocated within the mi_value_by_name() call. You do not need to supply the buffer to hold the returned value.
retlen	is the length of the returned column value.

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

The mi_value_by_name() function returns the value for the column that the column_name column name specifies. It retrieves this column value from the row structure that row references. The only difference between mi_value_by_name() and mi_value() is that the former accesses a column by its name while the latter accesses it by column identifier. Like mi_value(), the mi_value_by_name() function is typically called in a loop that terminates when mi_value_by_name() has retrieved values for all the columns in the row. For more information about how to get a value from a column, see the description of mi_value().

See the descriptions of the following functions: mi_collection_fetch(), mi_next_row(), mi_save_set_insert(), and mi_value().

For more information about how to retrieve values, see Obtaining Column Values.