[[{“value”:”At times there a coincidences, and this is one. I had been asked to add a UUID column to a SQL table that is sent to another application on a non-IBM server. My original plans were to use the MI program _GENUUID to generate the UUID. Then, to my delight I find that the latest Technology Refreshes, IBM i TR5 and IBM i TR11, includes two new SQL scalar functions that will generate an UUID. Which is ideal for me as I was using a SQL Insert statement to add data to the interface’s table.
What is UUID? Without going into too much detail, it stands for “Universally Unique Identifier”. It is administered by the Internet Engineering Task Force, IETF, with a standard, RFC9562, which defines it as: “A UUID is 128 bits long and is intended to guarantee uniqueness across space and time”. If you are interested in learning more the standard’s document is here.
In character form a version 4 UUID is 36 characters, and is formatted thus:
XXXXXXXX-XXXX-4XXX-XXXX-XXXXXXXXXXXX
Read more »”}]] Read More
