meta data for this page
  •  

F_UUID1MACMAC

function from adhoc

Entrypoint uuid1macmac compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(250)     valid UUID Version 1a
   Output     CSTRING(17)      MAC-adress of the computer where UUID was created

Syntax

   TestSQL (to use with TestISO.GDB)
   If you take a compressed UUID for input instead of a normal UUID:
   SELECT UUIDTESTID, F_UUIDVERSION(UUID), ART, NULL AS ISCORRECT, F_UUID1MACMAC(UUIDCOMPR) FROM UUIDTEST ORDER BY 1;
   If you take a normal UUID for input (right):
   SELECT UUIDTESTID, F_UUIDVERSION(UUID), ART, MACADRESS AS ISCORRECT, F_UUID1MACMAC(UUID) FROM UUIDTEST ORDER BY 1;
   SELECT NULL AS ISCORRECT, F_UUID1MACMAC(NULL) FROM RDB$DATABASE;