Advanced SQL Engine | Teradata Locale Definition (tdlocaledef) | Vantage - Overview - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢
The utility described is not available for as-a-service customers.

The Teradata Locale Definition utility, tdlocaledef, is a command-line utility that allows you to define or change how Teradata Database formats numeric, date, time, and currency output.

Tdlocaledef converts a specification for data formatting (SDF) text file into a Teradata Database globally distributed object (GDO), an internal binary format file that stores configuration information. The GDO is made available simultaneously to all nodes of an MPP system. The utility can also convert the text file to a local, non-distributed, binary file, that can be converted back to text in order to ensure the formatting syntax is valid.

Format changes take effect only after Teradata Database is restarted, and do not affect columns that were created prior to the restart.