DECIMAL types are stored in the proprietary C-ISAM format. They require a standard PROIV storage format of the form:

{S} i . f

where the optional S indicates a signed number, i is a number of integer digits, and f is a number of fractional digits (for example 5.2 or S3.1).  The size of a DECIMAL data type field can be calculated using the following formula:

number of bytes = INT (i/2 + 1/2) + INT (f/2 + 1/2) + 1

Documentation: See the Sizing DECIMALTYPE Data Type Numbers section in your C-ISAM Programmer's Manual for further details.

 

Comment on this topic

Topic ID: 720054