How to adjust length and scale of decimal datatype?

av686165

• March 17, 2020 00:00

• Answered

Follow

How to adjust length and scale of decimal datatype? By default, the decimal datatype is adjusted as (12,2), but I want it as 12,4 or 12,5

• 

  Vladimir Barton

  • March 20, 2020 14:08

  0

  Comment actions Permalink

  Hi there,
  the length and scale can be changed:
  

  
  
  • by editing the metadata (CloverDX Designer > Outline pane > Metadata),
  
  
  • in the Metadata Wizard, click on the desired decimal-type field,
  
  
  • locate the 'Length' and 'Scale' properties in the grid on the right,
  
  
  • change the values as desired, click on the 'Finish' button and save the changes.

  
  More information can be found in our documentation.
  Kind regards,

Please sign in to leave a comment.