UUIDASCHAR function

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

Syntax

If (source_character_uuid) is not specified, UUIDASCHAR creates a new UUID and returns it as a CHARACTER value.

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

The result is NULL if a NULL parameter is supplied.

Related concepts
ESQL

Related tasks
Developing ESQL

Related reference
Syntax preference
Miscellaneous ESQL functions