DataBlade API Programmer's Manual Chapter 12: DataBlade API Function Descriptions

Home

Contents

Index

Master Index

New Book

mi_integer mi_exec_prepared_statement(stmt, control, are_binary, n_params,

	values, lengths, nulls, types, retlen, rettypes)

		MI_STATEMENT *stmt;

		mi_integer control;

		mi_integer are_binary;

		mi_integer n_params;

		MI_DATUM values[];

		mi_integer lengths[];

		mi_integer nulls[];

		mi_string *types[];

		mi_integer retlen;

		mi_string *rettypes[]; 


stmt
is a pointer to a prepared statement as generated by mi_prepare().

control
is one of the following flags:


MI_BINARY
return binary results. If this flag is not set, ASCII results are returned.


MI_SEND_SENSITIVE
cursor is sensitive (not currently supported)


MI_SEND_READ
cursor is read only


MI_SEND_SCROLL
cursor is scrollable

are_binary
is set to 1 if the parameters are passed in binary mode.

n_params
is the number of entries in the nulls, lengths, and values arrays.

values
is an array of pointers to the statement parameters.

lengths
is an array of the lengths of the parameter values.

nulls
is an array that contains the value 1 for each null parameter and 0 for each non-null parameter.

types
is an array of pointers to the input parameter types. This array can be NULL.

retlen
is the length of the rettypes array. It must equal the number of columns returned by the statement or be 0 if there are no parameters.

rettypes
is an array of pointers to the type names to which the return columns are cast. It can be NULL if there is no need to cast the results.





 



Valid in Client Application?

Valid in Server Routine?

Yes
Yes