Loading JSON Data Example | Teradata Vantage - Loading JSON Data Example - Advanced SQL Engine - Teradata Database

In this example, the transform group settings for the user specify to use the TD_JSON_VARBYTE transform group. The following shows how you can load JSON data into the JSON column of the jsn_byte_bson table.

.logon NODEID/dr171210_vb,dr171210_vb;
 
DROP TABLE Error_11;
DROP TABLE Error_22;
 
CREATE TABLE jsn_byte_bson(
  s1 INTEGER NOT NULL
 ,s2 JSON (1000) STORAGE FORMAT BSON)
UNIQUE PRIMARY INDEX(s1);
 
DEFINE JOB TPT (
  a (INTEGER),
  b (VARBYTE(1000))
FILE=jsn_byte_bson;
 
BEGIN LOADING jsn_byte_bson ErrorFiles Error_11, Error_22 indicators;
 
INSERT INTO jsn_byte_bson VALUES(:a, :b);
END LOADING;
LOGOFF;