Syntax - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™
void
FNC_GetJSONInfo ( JSON_HANDLE   jsonHandle,
                  int          *maxLength,
                  charset_et   *charset,
                  int          *numLobs)
JSON_HANDLE jsonHandle
a handle to a JSON type instance.
JSON_HANDLE is defined in sqltypes_td.h as:
typedef int JSON_HANDLE;
int*maxLength
the maximum possible length of the JSON instance in bytes.
charset_et *charset
the character set of the JSON text, which is either UNICODE or LATIN.
int *numLobs
the number of LOBs used to store the JSON data. Valid values are as follows:
  • 0, which indicates that the data is not stored as a LOB
  • 1, which indicates that the data is stored as a LOB