IBM DB2 Error Code -542 – column-name cannot be a column of a hash

In this post, you’ll learn about the IBM DB2 Error -542 and the reason why you are receiving it

IBM DB2 Error Code :

-542

Reason for this Error in DB2

column-name CANNOT BE A COLUMN OF A HASH KEY, PRIMARY KEY, A UNIQUE CONSTRAINT, OR A PARENT KEY BECAUSE IT CAN CONTAIN NULL VALUES