Informix DataBlade API Programmer's Manual DataBlade API Function Descriptions

The mi_parameter_precision() function obtains the precision of the column associated with the specified input parameter in a prepared statement.

mi_integer mi_parameter_precision(stmt_desc, param_id)

MI_STATEMENT *stmt_desc;

mi_integer param_id;

stmt_desc	is a pointer to the statement descriptor for the prepared statement that contains the input parameter.
param_id	indicates the parameter identifier of the column, which specifies the position of the input parameter in the specified statement descriptor. Input-parameter numbering follows C programming conventions: the first parameter in the statement is at position zero (0).

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

The mi_parameter_precision() function obtains the precision of the column that is associated with the param_id input parameter from the statement descriptor that stmt_desc references. This function is an accessor function for a statement descriptor, which describes a prepared statement. The statement descriptor stores information about the precisions of input-parameter columns in the zero-based parameter-precision array. To obtain information about the nth input parameter, use a param_id value of n-1.

The precision is an attribute of the column data type that represents the total number of digits the column associated with an input parameter can hold, as follows.

If you call mi_parameter_precision() on an input parameter whose column is some other data type, the function returns zero (0).

Parameter information is available only for the INSERT and UPDATE statements. Support for the UPDATE statement includes the following forms of UPDATE:

• UPDATE with or without a WHERE clause
• UPDATE WHERE CURRENT OF

If you attempt to request parameter information for other SQL statements, mi_parameter_precision() raises an exception.

See the descriptions of the following functions: mi_close_statement(), mi_exec_prepared_statement(), mi_fetch_statement(), mi_get_statement_row_desc(), mi_parameter_count(), mi_parameter_nullable(), mi_parameter_scale(), mi_parameter_type_id(), mi_parameter_type_name(), mi_prepare(), and mi_statement_command_name().