UUID

Generate a universally unique id that is 36 characters long using the underlying Java UUID class and its secure random number generate to create the id.

Setup Syntax

CREATE FUNCTION UUID() RETURNING CHAR(36) EXTERNAL NAME 'com.informix.judrs.IfxStrings.getUUID()' language java;
GRANT EXECUTE ON UUID() TO PUBLIC;

Usage

CREATE TABLE test(a char(36), b int);
INSERT INTO test VALUES(UUID(), 5);
SELECT * FROM test;
a                                              b
d8948d42-7b56-4dd3-b522-51a07c818e14           5
1 row(s) retrieved.