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()