15.10 - Example: Get the Text Representation of BSON Data - Teradata Database

Teradata Database Teradata JSON

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
TeradataJSON_15_10.ditamap
dita:ditavalPath
ft:empty

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"}