16.10 - DotNotationOnErrorCondition - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

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.