CODEWITHSUNDEEP
db2db2-zos
killer
killer

Reputation: 11

Differences between default fields definition

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

Upvotes: 0

Views: 85

Answers (2)

kendrick
kendrick

Reputation: 26

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)

Upvotes: 1

Charles
Charles

Reputation: 23793

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

The default ends up being 000000000000000.000

Upvotes: 1

Related Questions