getJSONStorageFormat() - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
rin1593638965306.ditamap
dita:ditavalPath
rin1593638965306.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™

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