HP 3000 Manuals

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