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.
- boolean_constant
- true or false
- null
- JSON null.