Example: Get the Text Representation of BSON Data - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ JSON Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K

In this example, the column j1 contains JSON data in BSON format. The AsJSONText method is called to get the text representation of this BSON data.

CREATE TABLE jsonTable(id INTEGER, j1 JSON STORAGE FORMAT BSON);

/*insert {"hello": "world"} as BSON*/
INSERT INTO jsonTable(1, '160000000268656C6C6F0006000000776F726C640000'xb);

SELECT j1.AsJSONText() FROM jsonTable;

Result:

j1.AsJSONText()
------------------
{"hello": "world"}