[Locale:local-name] Section

[Locale:locale-name] defines the default settings for the locale identified by locale-name (which can consist of A-Z, 0-9, hyphen, or underscore). A number of locales are predefined in SQR.INI. Depending on your application, the settings for these locales may have to be altered or new locales may have to be added. A locale can be referenced or altered at run time using ALTER‑LOCALE.

Note:

The SYSTEM locale is provided for your reference, but is commented out. The settings for the SYSTEM locale, if set, are ignored. Use ALTER‑LOCALE to change the SYSTEM locale settings at run time.

Table 80. Entries in [Locale:locale-name]

Entry	Description
NUMBER‑EDIT‑MASK	Default numeric edit mask format when the keyword NUMBER accompanies DISPLAY, MOVE, PRINT, or SHOW.
MONEY‑EDIT‑MASK	Default numeric edit mask format when the keyword MONEY accompanies DISPLAY, MOVE, PRINT, or SHOW.
DATE‑EDIT‑MASK	Default date edit mask format when the keyword DATE accompaniesDISPLAY, MOVE, PRINT, or SHOW, or the LET datetostr() or strtodate() functions.
INPUT‑DATE‑EDIT‑MASK	Default date format to use with the INPUT command when TYPE=DATE is specified with the command or the input variable is a DATE variable. If this entry is not specified, then the date must be entered in one of the formats in Table 62, DATE Column Formats.
MONEY‑SIGN	Character(s) to replace the '$' edit character.
MONEY‑SIGN‑LOCATION	MONEY-SIGN character(s) location. Valid values are LEFT and RIGHT.
THOUSAND‑SEPARATOR	Character to replace the ',' edit character.
DECIMAL‑SEPARATOR	Character to replace the '.' edit character.
DATE‑SEPARATOR	Character to replace the '/' character.
TIME‑SEPARATOR	Character to replace the ':' character.
EDIT‑OPTION‑NA	Character(s) to replace the 'na' option.
EDIT‑OPTION‑AM	Character(s) to replace 'AM'.
EDIT‑OPTION‑PM	Character(s) to replace 'PM'.
EDIT‑OPTION‑AD	Character(s) to replace 'AD'.
EDIT‑OPTION‑BC	Character(s) to replace 'BC'.
DAY‑OF‑WEEK‑CASE	How the case for the DAY-OF-WEEK-FULL or DAY‑OF-WEEK-SHORT entries are affected when used with the format codes 'DAY' or 'DY'. Valid values are UPPER, LOWER, EDIT, and NO-CHANGE. UPPER and LOWER forces the output to either all uppercase or lowercase, ignoring the case of the format code in the edit mask. Use EDIT to follow the case as specified with the format code in the edit mask. Use NO-CHANGE to ignore the case of the format code and output the day of week as explicitly listed in the DAY‑OF‑WEEK‑FULL or DAY-OF-WEEK-SHORT entries.
DAY‑OF‑WEEK‑FULL	Full names for the days of the week. Production Reporting considers the first day of the week to be Sunday. All seven days must be specified.
DAY‑OF‑WEEK‑SHORT	Abbreviated names for the days of the week. Production Reporting considers the first day of the week to be Sunday. All seven abbreviations must be specified.
MONTHS‑CASE	How the case for the MONTHS-FULL or MONTHS‑SHORT entries is affected when used with the format codes 'MONTH' or 'MON'. Valid values are UPPER, LOWER, EDIT, and NO-CHANGE. UPPER and LOWER force the output to either all uppercase or lowercase, ignoring the case of the format code in the edit mask. Use EDIT to follow the case as specified with the format code in the edit mask. Use NO-CHANGE to ignore the case of the format code and output the month as explicitly listed in the MONTHS‑FULL or MONTHS-SHORT entries.
MONTHS‑FULL	Full names for the months of the year. Production Reporting considers the first month of the year to be January. All 12 months must be specified.
MONTHS‑SHORT	Abbreviated names for the months of the year. Production Reporting considers the first month of the year to be January. All 12 abbreviations must be specified.

Table 81. Date Column Formats

Database	DATE Column Formats
DB2	YYYY-MM-DD
INFORMIX	MM/DD/YYYY
ODBC	DD-MON-YYYY

Table 82. Time Column Formats

Database	TIME Column Formats
DB2	HH24.MI.SS
ODBC	HH24:MI:SS