meta data for this page
  •  

F_UUID1MACCOMPRMAC

function from adhoc

Entrypoint uuid1maccomprmac compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(250)     valid compressed UUID version 1a
   Output     CSTRING(17)      MAC-address of the computer where UUID was created

Syntax

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