The CDCUUID function retrieves the UUID from the current record. If the record does not contain a UUID, the function returns a null value with a length of 0. When present, the UUID is stored as a 16-byte binary value in the CDC record.
Category
Change Data Capture
Syntax
CDCUUID(UUID[,'FORMAT'])
Parameter and Description
| Parameter | Description |
|---|---|
| source_datastore | The name of the source datastore that contains the changed data capture (CDC) records. |
- If you specify the optional "FORMAT" argument, the UUID will be returned in the standard 36-character string format. For example:
"f81d4fae-7dec-11d0-a765-00a0c91e6bf6" - If you do not specify the "FORMAT" argument, the UUID will be returned as a simple 32-character string, which is a hexadecimal representation of the 16-byte binary UUID. For example:
f81d4fae7dec11d0a76500a0c91e6bf6