Connect CDC SQData

Convert a record to a json notation

Category

Format

Syntax

TO_JSON(datastore alias, record_alias [, 'AFTER' | 'BEFORE' ])

Parameter Descriptions

datastore alias  -  The alias of an input datastore.

'AFTER'  -  Select the after image, quotes are required. This is the default.

'BEFORE'  -  Select the before image, quotes are required. This only make sense for update record of a cdc input datastore.

Example

This converts the given record to a string representing it in json. Note, JSON string are always in utf-8.