IBM Books

Precision

This field displays the precision currently specified for the column of data type DECIMAL. You cannot alter this field for an existing column. To change the precision for a column that you're adding, type a new value in this field. The precision is the total number of digits in a DECIMAL number, which can range from 1 to 31. If you do not specify the precision, a default value of 5 is used.

This field is available only if you specified DECIMAL in theData type box and only for a new column.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]