EFFECTS OF NLS ON QUERY [ QUERY/V Reference Manual ] MPE/iX 5.0 Documentation
QUERY/V Reference Manual
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 thousands separator) to the
corresponding characters in the user's language.
The commands in Table D-1 are used to obtain language-dependent
information.
Table D-1. Commands for Language-Dependent Information
---------------------------------------------------------------------------------------------
| | |
| COMMAND | LANGUAGE-DEPENDENT INFORMATION| |
| | |
---------------------------------------------------------------------------------------------
| | |
| HELP LANGUAGE= | Explains the LANGUAGE= command function, format and |
| | parameters. |
| | |
| LANGUAGE= | Specifies the user language. |
| | |
| SHOW LANGUAGE | Displays the QUERY user's language. |
| | |
| FORM | Displays the data base language attribute. |
| | |
---------------------------------------------------------------------------------------------
Additional Discussion
Refer to the Native Language Support Reference Manual for a complete
description of Native Language Support. Refer to Section 3 for further
discussion of these commands.
MPE/iX 5.0 Documentation