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

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.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 Vantage formats numeric, date, time, and currency output.

tdlocaledef converts a specification for data formatting (SDF) text file into a Teradata 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 the database is restarted, and do not affect columns that were created prior to the restart.