17.10 - SDFファイルの例 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - データベース ユーティリティ

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
2021年7月
Content Type
構成
Publication ID
B035-1102-171K-JPN
Language
日本語 (日本)

例: Vantageのデフォルトのロケール書式設定

// 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 {""}

例: 日本語データ形式設定向けにカスタマイズされたSDF

この例では、SDFファイルが日本語が使用される状況でどのようにカスタマイズされるかを示します。このSDFには、日本語の日付および時刻のデフォルト書式設定と、漢字用のUnicodeの16進表記が含まれています。また、デフォルト形式列におけるUnicode文字は、“\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 {""}