For decimal type data, Toad for DB2 only display the data with a scale value of 6. How to change the scale to display the data entire value?
Example:
create table t1 (c1 decimal(30,15));
1. Open Tools | Options dialog and go to Environment | Grid page.
2. Select "Custom" tab in Data Type Formatting control
3. Click Add and create new type with following parameters:
Type Name = DECIMAL
Format Type = Numeric
Format String = ###############################.##############################
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center