informix
Informix DataBlade API Programmer's Manual
DataBlade API Function Descriptions

mi_fp_retprec()

The mi_fp_retprec() accessor function obtains the precision of a return value of a user-defined function from its associated MI_FPARAM structure.

Syntax

Usage

The mi_fp_retprec() function obtains the precision of the routine return value at position ret_pos from the MI_FPARAM structure that fparam_ptr references.

The precision is an attribute of the data type that represents the total number of digits the routine return value can hold, as follows.

Data Type Meaning
DECIMAL, MONEY Number of significant digits in the fixed-point or floating-point (DECIMAL) column
DATETIME, INTERVAL Number of digits that are stored in the date and/or time column with the specified qualifier
Character,
Varying-character
Maximum number of characters in the column

If you call mi_fp_retprec() on some other data type, the function returns zero (0).

The MI_FPARAM structure stores information about the precision of function return values in the zero-based return-precision array. To obtain information about the nth return value, use a ret_pos value of n-1. For example, the following call to mi_fp_retprec() obtains the precision for the first return value of the my_func() user-defined function, with which fparam1 is associated:

Important: C user-defined functions always have only one return value.

Return Values

>=0 is the precision, in number of digits, of the fixed-point or floating-point return value at position ret_pos.
MI_ERROR indicates that the function was not successful.

Related Topics

See the descriptions of the following functions: mi_fp_argprec(), mi_fp_retlen(), mi_fp_retscale(), mi_fp_rettype(), mi_fp_returnisnull(), mi_fp_setargprec(), and mi_fp_setretprec().


Informix DataBlade API Programmer's Manual, Version 9.2
Copyright © 1999, Informix Software, Inc. All rights reserved