How Format Specifications are Handled | Basic Teradata Query - 17.00 - Inheriting Defaults - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

The first set of database user sessions in a BTEQ execution automatically adopts the default format specifications.

If changes are made to the format specifications during the first session, the second set of sessions within the same BTEQ execution inherits the format specifications as they exist at the end of the first set of sessions.

Subsequent sessions do not automatically revert to the default format specifications.