PeriodStructOn Flag | Data Types and Literals | Teradata Vantage - 17.10 - PeriodStructOn Flag - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

The PeriodStructOn flag in the Options parcel allows the client to request PERIOD struct metadata, null indicator bits, and data values from the database in response messages.

The PeriodStructOn flag is stored in pcloptlist_t (pcltoteq.h).

The client sending PERIOD struct values to Vantage in request messages is independent from the client setting the Option parcel flag to request that Vantage return PERIOD struct values in response messages.

Values

Value Description
Y Default.

Request PERIOD struct metadata, null indicator bits, and data values from Vantage.

The Period data type value is exported as its date/time/timestamp attributes.

Vantage accepts (but does not require) PERIOD struct metadata, null indicator bits, and PERIOD struct data values from the client.

N Do not request PERIOD struct metadata, null indicator bits, and data values from Vantage.

See Transforms Off and Period Data Type Support for more information on setting these values.

When either the BEGIN or END PERIOD attributes is null, the PERIOD value is null. Therefore, null PERIOD values sent from Vantage to the client have all three null indicator bits set to indicate that the PERIOD value is null, and that the BEGIN and END attributes are also null. If the client sends null BEGIN or END PERIOD attributes, Vantage considers the PERIOD value to be null.