StatementInfo Parcel - Advanced SQL Engine - Teradata Database

The following fields of the StatementInfo Parcel contain information relevant to a particular instance of the JSON data type and show typical values that are expected for the JSON data type:

• Data Type Code = JSON Data Type, according to the table in the Data Type Encoding section.
• UDT indicator = 0 (JSON data type is treated as a system built-in type)
• Fully qualified type name length = 0
• Fully qualified type name = ""
• Field Size = the maximum possible length in bytes for this particular JSON instance
• Character Set Code = 1 or 2, depending on the character set for this particular JSON instance
• Maximum number of characters = number of characters of the JSON column - the same as number in the column definition
• Case Sensitive: 'Y' (JSON is case specific)

The "Data Type Misc Info" field provides information about the storage format of a JSON type.

Example: Metadata Parcel Sequence

This example shows a statement and the associated Metadata Parcel Sequence.

Consider the following table, data, and query.

CREATE SET TABLE jsontab ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      id INTEGER,
      jsoncol JSON(543000) CHARACTER SET UNICODE)
PRIMARY INDEX ( id );

INSERT INTO jsontab VALUES(1, NEW JSON('{"name":"Cameron"}', LATIN));

SELECT jsoncol FROM jsontab;

When executing the SELECT statement, the StatementInfo parcel looks like the following: