16.10 - Example SDF Files - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Example: Teradata Database default locale format settings

// File name     : tdlocaledef.txt   
// Purpose       : This file contains the specifications for data formatting(SDF) 
//                 defined by the user.      
// Scope         : Project - subsystems 
// Required files: None
// History       :  05-21-2001 - Created
//                  10-27-2005 - Added BIGINT
//                  05-24-2010 - Added TimeZoneString
// Description   : This data is compatible with pre-V2R5 releases. 
// DBS System Formatting Data 
// Day and month names
      ShortDays { 
          "Sun";
          "Mon";
          "Tue";
          "Wed";
          "Thu";
          "Fri";
          "Sat"
      }
      LongDays { 
          "Sunday";
          "Monday";
          "Tuesday";
          "Wednesday";
          "Thursday";
          "Friday";
          "Saturday"
      }
      ShortMonths { 
          "Jan";
          "Feb";
          "Mar";
          "Apr";
          "May";
          "Jun";
          "Jul";
          "Aug";
          "Sep";
          "Oct";
          "Nov";
          "Dec"
      }
      LongMonths { 
          "January";
          "February";
          "March";
          "April";
          "May";
          "June";
          "July";
          "August";
          "September";
          "October";
          "November";
          "December"
      }
      AMPM { 
          "AM";
          "PM"
      }
      // Parsing Elements
      RadixSeparator {"."}
      GroupSeparator {","}
      GroupingRule   {"3"}
      Currency       {"$"}
      ISOCurrency    {"USD"}
      CurrencyName    {"US Dollars"}
      CurrencyRadixSeparator {"."}
      CurrencyGroupSeparator {","}
      CurrencyGroupingRule   {"3"}
      DualCurrency    {"$"}
      DualISOCurrency {"USD"}
      DualCurrencyName {"US Dollars"}
      // Data type default formats
      BYTEINT        {"-(3)9"}
      INTEGER        {"-(10)9"}
      SMALLINT       {"-(5)9"}
      BIGINT         {"-(19)9"}
      NUMERIC        {"--(I).9(F)"}
      REAL           {"-9.99999999999999E-999"}
      DATE           {"YY/MM/DD"}
      TIME           {"HH:MI:SS.S(F)Z"}
      TIMESTAMP      {"YYYY-MM-DDBHH:MI:SS.S(F)Z"}
      NUMBER         {"FN9"}
      // System Time Zone string
      TimeZoneString {""}

Example: Customized SDF for Japanese Data Formatting

This example shows how an SDF file might be customized for a Japanese location. The file contains Japanese date and time default formatting and the Unicode hex notation for Kanji characters. Also, Unicode characters in the default format strings are specified with “\u.”

// DBS System Formatting Data
// Day and month names
      ShortDays {
          "\u65E5";
          "\u6708";
          "\u706B";
          "\u6C34";
          "\u6728";
          "\u91D1";
          "\u571F"
      }
      LongDays {
          "\u65E5\u66DC\u65E5";
          "\u6708\u66DC\u65E5";
          "\u706B\u66DC\u65E5";
          "\u6C34\u66DC\u65E5";
          "\u6728\u66DC\u65E5";
          "\u91D1\u66DC\u65E5";
          "\u571F\u66DC\u65E5"
      }
      ShortMonths {
          "1\u6708";
          "2\u6708";
          "3\u6708";
          "4\u6708";
          "5\u6708";
          "6\u6708";
          "7\u6708";
          "8\u6708";
          "9\u6708";
          "10\u6708";
          "11\u6708";
          "12\u6708"
      }
      LongMonths {
          "1\u6708";
          "2\u6708";
          "3\u6708";
          "4\u6708";
          "5\u6708";
          "6\u6708";
          "7\u6708";
          "8\u6708";
          "9\u6708";
          "10\u6708";
          "11\u6708";
          "12\u6708"
      }
      AMPM {
          "\u5348\u524D";
          "\u5348\u5F8C"
      }
      // Parsing Elements
      RadixSeparator         {"."}
      GroupSeparator         {","}
      GroupingRule           {"3"}
      Currency               {"\u00A5"}
      ISOCurrency            {"JPY"}
      CurrencyName           {"Yen"}
      CurrencyRadixSeparator {"."}
      CurrencyGroupSeparator {","}
      CurrencyGroupingRule   {"3"}
      DualCurrency           {"\u00A5"}
      DualISOCurrency        {"JPY"}
      DualCurrencyName       {"Yen"}
      // Data type default formats
      BYTEINT        {"-(3)9"}
      INTEGER        {"G-(I)9"}
      SMALLINT       {"G-(I)9"}
      BIGINT         {"G-(I)9"}
      NUMERIC        {"G--(I)D9(F)"}
      REAL           {"G-9D99999999999999E-999"}
      DATE           {"YYYY\u5E74MM\u6708DD\u65E5"}
      TIME           {"HH\u6642MI\u5206SSDS(F)\u79D2Z"}
      TIMESTAMP      {"YYYY\u5E74MM\u6708DD\u65E5BHH\u6642MI\u5206SSDS(F)\u79D2Z"}      NUMBER         {"FN9"}
      // System Time Zone string
      TimeZoneString {""}