Floating Point Specification for Unload
In the unload and reload command files, the floating point specification defaults to maximum precision and length (‑f8F79.38).
To reduce precision or length, edit the floating point specification in these files. If you do not, zeros with no significance can consume disk space in the external data files. If overflow occurs, you can specify another flag for the output format, for example, N instead of F in the floating point specification.
Precision of formatted character output of floating point numbers is also controlled with the -f flag of the sql command. For details, see the Command Reference Guide.