Informix DataBlade API Programmer's Manual DataBlade API Function Descriptions

The mi_current_command_name() function returns the name of the SQL statement that invoked the C UDR.

mi_string *mi_current_command_name(*conn)

MI_CONNECTION *conn;

conn	is a pointer to the connection descriptor that a previous call to mi_open(), mi_server_connect(), or mi_server_reconnect() has established.

Valid in Client LIBMI Application?	Valid in User-Defined Routine?
No	Yes

The mi_current_command_name() function returns the name as a null-terminated string in memory that it allocates in the current memory duration. This statement name is only the verb of the statement, not the entire statement syntax.

For example, suppose the following statement executes:

DELETE FROM customer WHERE customer_id = 1998

The mi_current_command_name() function returns only the verb of this statement: delete.

The conn parameter is redundant when you call mi_current_command_name() within the context of a user-defined routine. This function is useful in user-defined routines that need to know what kind of SQL statement caused them to be invoked.

Important: You can use the mi_current_command_name() function to obtain the SQL statement that invoked a C UDR. The mi_result_command_name() function returns the name of the current statement. You can obtain the name of a prepared statement with the mi_statement_command() function.

Return Values

mi_string *	is a pointer to the verb of the last statement or command.
NULL	indicates that the function was not successful or no current statement exists.

See the description of the following functions: mi_get_result(), mi_result_command_name(), and mi_statement_command().