DBFLTMASK environment variable

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 specified number of digits.

scale: is the number of decimal digits that you want the HCL OneDB™ 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.