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

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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
2021年7月
Language
日本語
Last Update
2021-09-23
dita:mapPath
ja-JP/xha1591998860283.ditamap
dita:ditavalPath
ja-JP/wrg1590696035526.ditaval
dita:id
B035-1102
Product Category
Software
Teradata Vantage

例: 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 {""}