Convert a record to a json notation.
Category
Format
Syntax
TO_JSON(datastore alias, record_alias, [, AFTER | BEFORE ])
Parameters and Descriptions
| Parameter | Description |
|---|---|
| datastore alias | The alias of an input datastore. |
| AFTER | Select the after image. This is the default. |
| BEFORE | Select the before image. Use this parameter to update records for a cdc input datastore. |
Example
This convert the given record to a string representing it in json.
Note: JSON string are always in utf-8.