Purpose
Determines how Teradata Database responds when queries using dot notation return a list of values.
Field Group
General
Valid Settings
| Setting | Description |
|---|---|
| 0 | Teradata Database returns a warning and an error string when a query using pre-16.00 dot notation returns a list of values. For newer elements added in Teradata Database 16.00, Teradata Database returns the list of values. |
| 1 | Teradata Database returns the list of values in all cases when a dot-notation query returns a list. |
| 2 | Teradata Database returns NULL in all cases when a dot-notation query returns a list. |
| 3 | Teradata Database returns an error in all cases when a dot-notation query returns a list. |
Default
0
Changes Take Effect
After the DBS Control Record has been written.
Usage Notes
Dot notation versions prior to Teradata Database 16.00 do not natively support returning lists of data.
Related Topics
| For More Information on… | See… |
|---|---|
| dot notation data types | Teradata DATASET Data Type and Teradata JSON. |