DB2 如何生成UUID

DB2 怎么生成UUID
在DB2里，用SQL怎么生成UUID？有没有相关函数？

[解决办法]
收藏的自定义生成固定位数随机数的方法

SQL code

CREATE FUNCTION DB2INST1.F_RANDOM ("IN_LENGTH" INTEGER )   RETURNS INTEGER  SPECIFIC DB2INST1.F_RANDOM  LANGUAGE SQL  NOT DETERMINISTIC  READS SQL DATA  STATIC DISPATCH  CALLED ON NULL INPUT  EXTERNAL ACTION  INHERIT SPECIAL REGISTERS  BEGIN atomic    declare v_newLength INTEGER;    declare v_random INTEGER;    declare v_length INTEGER;    declare v_index INTEGER;    declare out_result VARCHAR(30);    IF in_length > 30 THEN      RETURN 0;    END IF;        SET v_random = INTEGER(RAND()*POWER(10,in_length));    SET v_length = in_length - LENGTH(RTRIM(CHAR(v_random)));    SET v_index = 1;    SET out_result = CHAR(v_random);    WHILE v_index <= v_length DO      SET out_result = CONCAT('8',out_result);--位数不够，前面补8      SET v_index = v_index + 1;    END WHILE;    SET v_random = INTEGER(out_result);    RETURN v_random;  END;
[解决办法]
http://publib.boulder.ibm.com/infocenter/tivihelp/v2r1/index.jsp?topic=/com.ibm.IBMDS.doc_5.2/admin_gd367.htm

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/r0000809.htm