0

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

killer
  • 11
  • 6

2 Answers2

1

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

The default ends up being 000000000000000.000

Charles
  • 21,637
  • 1
  • 20
  • 44
1

They are equivalent in this case. You can find the default values for different data types if you don't specify the values explicitly in the link ( https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/intro/src/tpc/db2z_defaultvalues.html)

kendrick
  • 26
  • 2