15.10 - column assignment - Teradata Database

Teradata Database Teradata JSON

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1150-151K

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.