db2 - Differences between default fields definition

Question

Db2 Z/OS Version 11.01 and 12.

I am verifying that the structure of some tables is equal on more customers/environments. I noticed that the default value is the only aspect that differs between many tables

For Example - Table "Order" Columns "PRICE"

  Environment 1 -> DECIMAL(18,3) NOT NULL WITH DEFAULT
  Environment 2 -> DECIMAL(18,3) NOT NULL WITH DEFAULT 0 
  Environment 3 -> DECIMAL(18,3) NOT NULL WITH DEFAULT 0.0

I am not sure if i have to consider theese "definitions" as technically and functionally equivalent or not.

Thanks

question from:https://stackoverflow.com/questions/65846610/differences-between-default-fields-definition

Answer 1

Yes, for a decimal(18,3) column, all three are functionally equivalent.

The default ends up being 000000000000000.000