Home
Extending Informix®Beyond standard relational database objects, HCL Informix® can be extended to handle specialized data types, access methods, routines, and other objects. Informix® includes many built-in extensions that are fully integrated in the database server. Informix® also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for Informix®.
Creating extensionsYou can create user-defined data types, routines, access methods, and other database objects to suit your needs. You can use application programming interfaces to write user-defined routines and applications that access data in Informix® databases.
DataBlade® API Programmer's GuideThe Informix® DataBlade® API Programmer's Guide describes information about the DataBlade® API, the C-language application programming interface (API) provided with HCL Informix®.
Data manipulation
Numeric data typesThis section describes these numeric data types and the functions that the DataBlade® API supports to process numeric data.
Fixed-point dataFixed-point data is a decimal value with a fixed number of digits to the right and left of the decimal point. The fixed number of digits to the right of the decimal point is called the scale of the value. The total number of digits in the fixed-point value is called the precision of the value.
Convert decimal dataBoth the DataBlade® API library and the Informix® ESQL/C library provide functions that convert the binary representation for DECIMAL (mi_decimal) or MONEY (mi_money) values.
DataBlade® API functions for decimal conversion

DataBlade API functions for decimal conversion

The DataBlade® API library provides the following functions that convert between a text (string) representation of a decimal or monetary value and its binary (internal) equivalent.


DataBlade API Function	Converts from	Converts to
mi_decimal_to_string()	DECIMAL (mi_decimal)	Decimal string
mi_money_to_string()	MONEY (mi_money)	Interval string
mi_string_to_decimal()	Decimal string	DECIMAL (mi_decimal)
mi_string_to_money()	Monetary string	MONEY (mi_money)

Server only: The mi_decimal_to_string(), mi_money_to_string(), mi_string_to_decimal(), and mi_string_to_money() functions are useful in the input and output support function of an opaque data type that contains mi_decimal or mi_money values. They allow you to convert fixed-point (DECIMAL or MONEY) values between their external format (text) and their internal format (dec_t) when transferred to and from client applications.

The mi_decimal_to_string(), mi_money_to_string(), mi_string_to_decimal(), and mi_string_to_money() functions use the current processing locale to handle locale-specific formats in the decimal or monetary string. For more information, see the Informix® GLS User's Guide.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.