{"id":133,"date":"2016-03-19T12:09:15","date_gmt":"2016-03-19T11:09:15","guid":{"rendered":"https:\/\/solidt.eu\/blog\/?p=133"},"modified":"2016-03-19T12:14:14","modified_gmt":"2016-03-19T11:14:14","slug":"iseries-create-a-guid-sql","status":"publish","type":"post","link":"https:\/\/solidt.eu\/site\/iseries-create-a-guid-sql\/","title":{"rendered":"iSeries: Create a GUID (SQL)"},"content":{"rendered":"<pre lang=\"sql\">\r\n\r\n-- Create a new random GUID (as Function)\r\nCREATE FUNCTION UUID()\r\nRETURNS CHAR(36)\r\nLANGUAGE SQL\r\nCONTAINS SQL\r\nNO EXTERNAL ACTION\r\nDETERMINISTIC\r\nRETURN LOWER( \r\n\tRIGHT(LPAD(HEX(INT(RAND() * 1000000000)), 8, '0'), 8) || '-' || \r\n\tRIGHT(LPAD(HEX(INT(RAND() * 1000000000)), 8, '0'), 4) || '-' ||\r\n\tRIGHT(LPAD(HEX(INT(RAND() * 1000000000)), 8, '0'), 4) || '-' ||\t\r\n\tRIGHT(LPAD(HEX(INT(RAND() * 1000000000)), 8, '0'), 4) || '-' ||\t\r\n\tRIGHT(LPAD(HEX(INT(RAND() * 1000000000)), 8, '0'), 8) || RIGHT(LPAD(HEX(INT(RAND() * 1000000000)), 8, '0'), 4)\r\n);\r\n\r\n\r\nINSERT INTO TABLE_GUIDS (Oid, Guid) VALUES (UUID(), UUID());\r\n\r\n-- Or inline\r\nBEGIN ATOMIC\r\n\tDECLARE @GUID CHAR(36) NOT NULL DEFAULT '';\r\n\tSET @GUID=LOWER( \r\n\t\tRIGHT(LPAD(HEX(INT(RAND() * 1000000000)), 8, '0'), 8) || '-' ||\r\n\t\tRIGHT(LPAD(HEX(INT(RAND() * 1000000000)), 8, '0'), 4) || '-' ||\r\n\t\tRIGHT(LPAD(HEX(INT(RAND() * 1000000000)), 8, '0'), 4) || '-' ||\r\n\t\tRIGHT(LPAD(HEX(INT(RAND() * 1000000000)), 8, '0'), 4) || '-' ||\r\n\t\tRIGHT(LPAD(HEX(INT(RAND() * 1000000000)), 8, '0'), 8) || RIGHT(LPAD(HEX(INT(RAND() * 1000000000)), 8, '0'), 4)\r\n\t\t);\r\n\r\n\t\t\t\r\n\tINSERT INTO TABLE_GUIDS (Oid, Guid) VALUES (@GUID, @GUID); \r\nEND\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&#8212; Create a new random GUID (as Function) CREATE FUNCTION UUID() RETURNS CHAR(36) LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC RETURN LOWER( RIGHT(LPAD(HEX(INT(RAND() * 1000000000)), 8, &#8216;0&#8217;), 8) || &#8216;-&#8216; || RIGHT(LPAD(HEX(INT(RAND() * 1000000000)), 8, &#8216;0&#8217;), 4) || &#8216;-&#8216; || RIGHT(LPAD(HEX(INT(RAND() * 1000000000)), 8, &#8216;0&#8217;), 4) || &#8216;-&#8216; || RIGHT(LPAD(HEX(INT(RAND() * 1000000000)), 8, &#8216;0&#8217;), [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[8],"tags":[],"class_list":["post-133","post","type-post","status-publish","format-standard","hentry","category-other-scripts"],"_links":{"self":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/comments?post=133"}],"version-history":[{"count":5,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/133\/revisions"}],"predecessor-version":[{"id":138,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/posts\/133\/revisions\/138"}],"wp:attachment":[{"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/media?parent=133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/categories?post=133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solidt.eu\/site\/wp-json\/wp\/v2\/tags?post=133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}