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 the Utilities - Volume 2 L-Z Guide. For more information, log in to https://access.teradata.com and search for KAP231E5E.