UUIDASCHAR function

UUIDASCHAR is a miscellaneous function that returns universally unique identifiers (UUIDs) as CHARACTER values.

Syntax

Read syntax diagramSkip visual syntax diagramUUIDASCHAR (source_blob_uuid)
If (source_blob_uuid) is not specified, UUIDASCHAR creates a UUID and returns it as a CHARACTER value. The UUID is generated as follows:
  • On Linux® and UNIX systems, a random number is generated from a combination of time, the IP address of the integration node, and the PID of the DataFlowEngine.
  • On Windows systems, the base C++ UuidCreate function is used.

If (source_blob_uuid) is specified, UUIDASCHAR converts an existing BLOB UUID to the character form.

The result is NULL if a NULL parameter is supplied.