17.10 - getJSONStorageFormat() - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

Retrieves the JSON storage format for a JSON column. Valid values match those used for the C structure json_storage_en. For information about this structure, see Table Operator Data Structures.

The method returns a constant of type short that contains the JSON storage format value corresponding to this JSON column.

The method throws SQLException if an error occurs while attempting to access the JSON storage format value. A database specific code “9744 (ERRUDFJAVUDT) <JSON Storage format could not be accessed>” is returned.

Syntax

short getJSONStorageFormat()
                       throws SQLException