Obtain row values

The mi_value() and mi_value_by_name() functions return the MI_ROW_VALUE value status for a column that meets either of the following conditions:
  • The column has a row type (a named or unnamed row type) as its data type.
  • The item being selected is a correlation variable that represents an entire row.
    A correlation variable is used in a select list when jagged rows are selected from a supertable in an inheritance hierarchy, as in the query:
    SELECT p FROM parent p;

When the mi_value() or mi_value_by_name() function returns MI_ROW_VALUE, the MI_DATUM structure that these functions pass back contains a pointer to the row structure, regardless of whether the query data is in binary or text representation. You can extract the individual values from the row structure by passing the returned MI_ROW pointer to mi_value() or mi_value_by_name() for each value you need to retrieve.