Hello I'm using DB2/LINUXX8664 and I would like to know the equivalent of the oracle function SYS_GUID() function in DB2 LUW.

create table ab(
uuid varchar2(36) default sys_guid());

The Code above is for Oracle, do we have this built-in function in DB2?

CodePudding user response：

Db2 LUW and IBMi both have GENERATE_UNIQUE()

But it returns a 13 byte binary string instead of the 16 byte binary string Oracle's function does.

In addition, Db2 doesn't support the use of a function in the DEFAULT clause for a column in a table definition.