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

Teradata Vantageā„¢ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)
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.