DBFLTMASK

The DB–Access utility displays the floating-point values of data types FLOAT, SMALLFLOAT, and DECIMAL(p) within a 14-character buffer. By default, DB–Access displays as many digits to the right of the decimal point as will fit into this character buffer. Therefore, the actual number of decimal digits that DB–Access displays depends on the size of the floating-point value.

To reduce the number of digits displayed to the right of the decimal point in floating-point values, set DBFLTMASK to the desired number of digits.

>>-setenv--DBFLTMASK--scale------------------------------------><
 

scale

is the number of decimal digits that you want the IBM Informix client application to display in the floating-point values. Here scale must be smaller than 16, the default number of digits displayed.

If the floating-point value contains more digits to the right of the decimal than DBFLTMASK specifies, DB–Access rounds the value to the specified number of digits. If the floating-point value contains fewer digits to the right of the decimal, DB–Access pads the value with zeros. If you set DBFLTMASK to a value greater than can fit into the 14-character buffer, however, DB–Access rounds the value to the number of digits that can fit.