15.00 - JSON_AttributeSize - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

JSON_AttributeSize

Purpose  

Denotes the size (number of characters) of attributes returned by the JSONExtractValue method and dot notation.

Field Group

General

Valid Range

0 through 32000 characters

Default

4096

Changes Take Effect

After the DBS Control Record has been written.

Example  

SELECT NEW JSON('{"name":"Cameron"}').name as NameAttribute;
 
NameAttribute
------------------------------------------------------------
Cameron

Related Topics

 

For More Information on…

See…

JSON data type

Teradata JSON.

Related DBS Control fields

“DisableJSONValidation” on page 307, “EnableJSON” on page 324, “JSON_MaxDepth” on page 352.