UUIDASCHAR function
UUIDASCHAR is a miscellaneous function that returns universally unique identifiers (UUIDs) as CHARACTER values.
Syntax
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.