Purpose
Returns the data length in bytes of any of the following Teradata variable maximum length complex data types:
- DATASET
- JSON
- ST_Geometry
- XML
Syntax
- var_max_length_cdt
- A DATASET, JSON, ST_Geometry, or XML data type object.
Return Value
Returns a BIGINT that is the size in bytes of the data object passed in to the function.
Examples: DataSize
The following examples use JSON data types.
SELECT TD_SYSFNLIB.DataSize (NEW JSON ('{"name" : "Mitzy", "age" : 3}'));
datasize( NEW JSON('{"name" : "Mitzy", "age" : 3}', LATIN))
-----------------------------------------------------------
29
CREATE TABLE JSON_table (id INTEGER, jsn JSON INLINE LENGTH 1000);
INSERT INTO JSON_table VALUES (100, '{"name" : "Mitzy", "age" : 3}');
INSERT INTO JSON_table VALUES (200, '{"name" : "Rover", "age" : 5}');
INSERT INTO JSON_table VALUES (300, '{"name" : "Princess", "age" : 4.5}');
SELECT * FROM JSON_table ORDER BY id;
id jsn
----------- ------------------------------------------
100 {"name" : "Mitzy", "age" : 3}
200 {"name" : "Rover", "age" : 5}
300 {"name" : "Princess", "age" : 4.5}
SELECT id, TD_SYSFNLIB.DataSize (jsn) FROM JSON_table ORDER BY id;
id datasize(jsn)
----------- --------------------
100 29
200 29
300 34