SQL statement processing

The DataBlade API provides the multiple categories of functions for processing SQL statements.

Table 1. Functions for processing SQL statements
Function category	DataBlade API function	DataBlade API function
Sending SQL statements	Executable-statement functions: mi_exec() mi_query_finish() mi_query_interrupt()	Prepared-statement functions: mi_close_statement() mi_drop_prepared_statement() mi_exec_prepared_statement() mi_fetch_statement() mi_get_cursor_table() mi_open_prepared_statement() mi_prepare()
Obtaining statement information	Input-parameter functions: mi_parameter_count() mi_parameter_nullable() mi_parameter_precision() mi_parameter_scale() mi_parameter_type_id() mi_parameter_type_name()	Other statement functions: mi_binary_query() mi_command_is_finished() mi_current_command_name() mi_get_id() mi_get_statement_row_desc() mi_statement_command_name()
Obtaining result information	mi_get_result() mi_result_command_name()	mi_result_reference() mi_result_row_count()
Retrieving rows, row data, row types, and row-type data	Row-descriptor functions: mi_get_row_desc() mi_get_row_desc_from_type_desc() mi_get_row_desc_without_row() mi_row_desc_create() mi_row_desc_free()	Row-structure functions: mi_next_row() mi_row_create() mi_row_free()
Retrieving columns	Column-information functions: mi_column_count() mi_column_default() mi_column_default_string() mi_column_id() mi_column_name() mi_column_nullable() mi_column_precision() mi_column_scale() mi_column_type_id() mi_column_typedesc()	Column-value functions: mi_value() mi_value_by_name()
Using save sets	mi_save_set_count() mi_save_set_create() mi_save_set_delete() mi_save_set_destroy() mi_save_set_get_first()	mi_save_set_get_last() mi_save_set_get_next() mi_save_set_get_previous() mi_save_set_insert() mi_save_set_member()