15.10 - column assignment - Teradata Database

The following describes the column assignment variables.

"columns" :

Required, literal entry.

"table_column_name'"

The name of any column in the table referenced by table_name. The user invoking JSON_SHRED_BATCH must have the required privileges (INSERT, UPDATE, and so forth) on this existing table. table_name must be the fully qualified table name. It is specified in the table expression of JSON_SHRED_BATCH.

"temp_column_name"

A temp_column_name defined in "colexpr" or "queryexpr". The temporary column name must be unique or an error is reported. Note: Temporary column names are not case sensitive, so col1 and COL1 are not unique and will cause an error.

"temp_expr"

Teradata SQL expression.

numeric_constant

Any JSON supported Numeric value.

["string_constant"]

Any JSON supported string value.

Example string constant: "company" : ["Teradata"]

boolean_constant

true or false

true and false are JSON keywords and must be lowercase.

null

JSON null.

null is a JSON keyword and must be lowercase.