SDF File - Analytics Database - Teradata Vantage

These names can vary in length. There must be seven values entered for this keyword.

Example:

ShortDays {"Sun";"Mon";"Tue";"Wed";"Thu";
"Fri";"Sat"}

The order of the names must match the order of the names of the ShortDays. These names can vary in length. There must be seven values entered for this keyword.

Example:

LongDays {"Sunday";"Monday";"Tuesday";
"Wednesday";"Thursday";"Friday";
"Saturday"}

These names can vary in length.There must be twelve values entered for this keyword.

Example:

ShortMonths {"Jan";"Feb";"Mar";"Apr";
"May";"Jun";"Jul";"Aug";"Sep";"Oct";"Nov";"Dec"}

The order of the names must match the order of the names of the ShortMonths. These names can vary in length. There must be twelve values entered for this keyword.

Example:

LongMonths {"January";"February";"March"; "April";"May";"June";"July";"August"; "September";"October";"November";
"December"}

These names can vary in length. There must be two values entered for this keyword.

Example:

AMPM {"AM";"PM"}

• plus sign (+)
• minus sign (-)
• digits (0 through 9)
• E
• e
• V
• v

The RadixSeparator value must be different from the GroupSeparator value. However, the RadixSeparator value can be the same as the CurrencyRadixSeparator value.

Example:

RadixSeparator {"."}

The GroupSeparator value can be the same as the CurrencyGroupSeparator value.

Example:

GroupSeparator {","}

GroupingRule {"3"}

For GroupingRule {“3”}, the numeric value 123456789.00 is formatted as 123,456,789.00.

GroupingRule {"3,2,-1"}

For GroupingRule {“3,2,-1”}, the numeric value 123456789.00 is formatted as 1234,56,789.00.

Examples of dollar, yen, and euro currency strings:

Currency {"$"}
Currency  {"\u00A5"} 
Currency  {"\u20AC"}

Example:

ISOCurrency {"USD"}

Example:

CurrencyName {"US Dollars"}

The value must be different that the value of CurrencyGroupSeparator.

Example:

CurrencyRadixSeparator {"."}

The value must be different that the value of CurrencyRadixSeparator.

Example:

CurrencyGroupSeparator {","}

The size of each group can vary. Each number specifies how many digits are in each group with the initial integer defining the size of the group immediately preceding the radix separator, and the following integers defining groups preceding that.

Example:

CurrencyGroupingRule {"3"}

Example:

DualCurrency {"$"}

Example:

DualISOCurrency {"USD"}

Example:

DualCurrencyName {"US Dollars"}

Example:

BYTEINT {"-(3)9"}

Example:

INTEGER {"-(10)9"}

Example:

SMALLINT {"-(5)9"}

Example:

BIGINT {"-(19)9"}

Example:

NUMERIC {"--(I).9(F)"}

• I represents the number of characters needed to display the integer portion of NUMERIC and INTEGER data. For example:
  • With INTEGER type, I is 10.
  • With DECIMAL type (10,2), I is 8
• F represents the number of characters required to display the fractional portion of NUMERIC data. For example, with DECIMAL type (10,2), F is 2.

Example:

REAL {"-9.99999999999999E-999"}

Example:

DATE {"YY/MM/DD"}

Example:

TIME {"HH:MI:SS.S(F)Z"}

Example:

TIMESTAMP {"YYYY-MMDDBHH:MI:SS.S(F)Z"}

The value is a sequence of strings that represents the time offset for the time zone.

Example:

{"GMT-8"; "-8"; "0"}

For locations that observe Daylight Savings Time (DST), the string can define the set of rules for when in the calendar year the system time zone offset should change. The system will automatically adjust for DST according to this code. For example:

Example:

{"America Pacific"; "-8"; "0"; "2"; "4"; "4"; "1"; "0"; "0"; "02:00:00"; "3"; "10"; "0"; "0"; "-1"; "02:00:00"; "1987"; "2006"; "-8"; "0"; "-7"; "0"; "4"; "3"; "8"; "0"; "0"; "02:00:00"; "4"; "11"; "1"; "0"; "0"; "02:00:00";"2007"; "9999"; "-8"; "0"; "-7"; "0"}