Locale Section

This section specifies the default settings for the locale identified by locale-name (which can consist of letters from A to Z, numbers from 0 to 9, a hyphen, and an underscore). LOCALE setting in SQR is a set of named values that is used to store regional settings. A number of locales are predefined in the pspssqr.ini file. Depending on your application, you may have to alter the settings for these locales or add new locales. You can generate region-specific SQR reports by personalizing or modifying the SQR scripts. Only users with authorized permission can generate a personalized SQR report.

For more information about user personalization, see Understanding My Preferences Personalizations .

You can reference or alter a locale at runtime using the ALTER-LOCALE command. The following table describes the entries for a locale section.

Note: The SYSTEM locale is provided for your reference but is commented out. The settings for the SYSTEM locale, if set, are ignored. Use the ALTER-LOCALE command to change the SYSTEM locale settings at runtime.

Personalization is done only for the following default locale parameters:

  • DATE-EDIT-MASK

  • THOUSAND-SEPARATOR

  • DECIMAL-SEPARATOR

  • DATE-SEPARATOR

  • TIME-SEPARATOR

Entry

Description

 
NUMBER-EDIT-MASK

Specifies the default numeric edit mask format when the keyword NUMBER accompanies the DISPLAY, MOVE, PRINT, or SHOW command.

 
MONEY-EDIT-MASK

Specifies the default numeric edit mask format when the keyword MONEY accompanies the DISPLAY, MOVE, PRINT, or SHOW command. 

DATE-EDIT-MASK

Specifies the default date edit mask format when the keyword DATE accompanies the DISPLAY, MOVE, PRINT, or SHOW command, or the LET datetostr() or strtodate() functions.

 
INPUT-DATE-EDIT-MASK

Specifies the 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.

 
MONEY-SIGN

Specifies the characters to replace the ($) edit character.

 
MONEY-SIGN-LOCATION

Specifies the location of the MONEY-SIGN character. Valid values are LEFT and RIGHT. 

THOUSAND-SEPARATOR

Specifies the character to replace the comma (,) edit character. 

DECIMAL-SEPARATOR

Specifies the character to replace the period (.) edit character.

 
DATE-SEPARATOR

Specifies the character to replace the slash (/) character.

 
TIME-SEPARATOR

Specifies the character to replace the colon (:) character.

 
EDIT-OPTION-NA

Specifies the characters to replace the NA option.

 
EDIT-OPTION-AM

Specifies the characters to replace AM.

 
EDIT-OPTION-PM

Specifies the characters to replace PM.

 
EDIT-OPTION-AD

Specifies the characters to replace AD.

 
EDIT-OPTION-BC

Specifies the characters to replace BC.

 
DAY-OF-WEEK-CASE

Specifies 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.

Use UPPER and LOWER to 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 day of week as explicitly listed in the DAY-OF-WEEK-FULL or DAY-OF-WEEK-SHORT entries.

 
DAY-OF-WEEK-FULL

Specifies the full names of the days of the week. SQR considers the first day of the week to be Sunday. You must specify all seven days.

 
DAY-OF-WEEK-SHORT

Specifies the abbreviated names for the days of the week. SQR considers the first day of the week to be Sunday. You must specify all seven abbreviations.

 
MONTHS-CASE

Specifies 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.

Use UPPER and LOWER to 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

Specifies the full names for the months of the year. SQR considers the first month of the year to be January. You must specify all 12 months.

 
MONTHS-SHORT

Specifies the abbreviated names for the months of the year. SQR considers the first month of the year to be January. You must specify all 12 abbreviations.