On Fri, 19 Mar 2021 22:55:25 +0000, Farley, Peter x23353 wrote: > >The GENERATE_UNIQUE function returns a bit data character string 13 bytes long >(CHAR(13) FOR BIT DATA) that is unique compared to any other execution of the >same function. The function is defined as not deterministic. Although the >function has no arguments, the empty parentheses must be specified when the >function is invoked. >The result of the function is a unique value that includes the internal form >of the Universal Time, Coordinated (UTC) and, if in a sysplex environment, the >sysplex member where the function was processed. >The result cannot be null. >The result of this function can be used to provide unique values in a table. >The sequence is based on the time when the function was executed. > Does "based" imply relative to the first call to the function?
>Sounds to me like the first 12 bytes of STCKE plus the last byte of the >"programmable field" in the STCKE result. > Peter R's statement implies that no proper substring of the STCKE value is guaranteed unique. It's surprising that any process requires so many UUIDs that performance is a concern. Must the values be sortable in chronological order? Are you free to disclose the maximum permitted value of your UUIDs? -- gil ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
