EFFECTS OF NLS ON QUERY

NLS can affect QUERY in upshifting data, range selection, data format, real number conversions, and sorted lists and numeric data editing in REPORT.

Upshifting Data (Type U Items)

QUERY upshifts commands and the data of type U items. QUERY commands are upshifted according to NATIVE-3000. Data is upshifted according to the user's language for UPDATE ADD, UPDATE REPLACE, FIND, LIST, MULTIFIND, and SUBSET.

Range Selection

QUERY compares character data according to the user's language when using FIND, LIST, MULTIFIND, or SUBSET. The MATCHING feature (in FIND and MULTIFIND commands) is only valid when LANGUAGE=0 (NATIVE-3000). QUERY will display an error message if MATCHING is used in an interactive mode, and will abort the session in a batch mode.

Date Format

DATE is a reserved word in the REPORT command which provides the system date. It is formatted according to the user's language.

Real Number Conversions

In the commands REPORT and LIST the output is formatted according to the user's language. For example, 123.45 in NATIVE-3000 becomes 123,45 in FRENCH.

Sorted Lists in REPORT

QUERY sorts type U or X items in a REPORT according to the collating sequence of the user's language.

Numeric Data Editing in REPORT

QUERY converts the data edited using the NATIVE-3000 edit mask (using the period as a decimal point and a comma as a thousands separator) to the corresponding characters in the user's language.

The commands in Table D-1 “Commands for Language-Dependent Information” are used to obtain language-dependent information.