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

Home

Contents

Index

Master Index

New Book

mi_integer mi_open_prepared_statement(stmt, control, are_binary, n_params,

	values, lengths, nulls, types, name, 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_string *name;

		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.



 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 1 for each null parameter and 0 for each non-null parameter.

types
is an array of pointer to the input parameters' types. If there are no parameters, this array can be NULL.

name
is a pointer to the name of the cursor. This cursor name must be unique. To use an internally-generated unique name for the cursor, specify NULL for the name argument.

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

rettypes
is an array of pointers to the type names to which the return values are cast. This array might be NULL if return values do not need to be cast.





 



Valid in Client Application?

Valid in Server Routine?

Yes
Yes