16.20 - The tdlocaledef Utility Output Format - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Node Software Migration Guide

Teradata Database
Teradata Vantage NewSQL Engine
March 2019
The Locale Definition utility (tdlocaledef) command-line utility allows you to define or change how Teradata Database formats numeric, date, time, and currency output.

The utility 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 syntax formatting validity.

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

The tdlocaledef utility uses the tdlocaledef.txt SDF file, which is located in the /etc/opt/teradata/tdconfig file.

After the data has been migrated, verify that the tdlocaledef.txt file on the destination system is the same as on the source system.
  • From a command prompt, start the Locale Definition utility: tdlocaledef
    Options for this command can be found in Teradata Vantageā„¢ - Database Utilities, B035-1102. For more information, log in to https://access.teradata.com and search for KAP231E5E.