Running QUERY |
 |
The following illustrates the procedure to initiate a QUERY
session.
RETURN
:HELLO MANAGER.DATAMGT,ACCOUNTS
HP3000 Release: C.60.00 User Version: C.60.00 FRI, OCT 29, 1999, 2:38 PM
MPE/iX HP31900 C.16.01 Copyright Hewlett-Packard 1987. All rights reserved.
:RUN QUERY.PUB.SYS
HP32216N.03.15 QUERYNM FRI, OCT 29, 1999, 2:39 PM
COPYRIGHT HEWLETT-PACKARD CO. 1976
>
or
:RUN QUERYCM.PUB.SYS
HP32216D.03.15 QUERYNM FRI, OCT 29, 1999, 2:49 PM
COPYRIGHT HEWLETT-PACKARD CO. 1976
>
Log on to the computer using the MPE :HELLO command. MPE prints
information about your session and another colon. Initiate QUERY
using the MPE :RUN command. QUERY prints the subsystem banner and
prompts for a command with >.
Accessing Data |
|
Before you can access data, you must open a data base by specifying
a data base name, password, and access mode. You can do this at
the beginning of your QUERY session by using the DATA-BASE= or DEFINE
command, both of which will prompt you with >> to supply
information. For example:
>DATA-BASE=ORDERS
PASSWORD = >>CLERK
MODE = >>5
> |
You may open additional data bases with the MULTIDB command
after you specify the primary data base with the DATA-BASE= or DEFINE
command. The data base opened with the DATA-BASE= or DEFINE command
is the primary data base. The primary data base is used by QUERY
when executing a command unless a data base opened with the MULTIDB
command is specified. You can change the primary data base at any
time with the DATA-BASE= or DEFINE command.
After opening the data base(s), QUERY can be used to add,
delete, replace, locate, and/or report data in the data base(s).
During QUERY execution, you may need to temporarily return to the
operating system to use the MPE :FILE command to direct output to
a specific device such as a line printer.
Using the Break Key |
|
You use the break key to temporarily return to the operating
system. After you have finished entering MPE commands, you return
to QUERY by using the MPE :RESUME command. MPE prints READ PENDING
to inform you that QUERY is waiting for a command. In this case,
QUERY does not print the > prompt until you press RETURN. For example:
>BREAK
:FILE QSLIST;DEV=TAPE
:RESUME
READ pending
RETURN
> |
Using Control Y |
|
Some QUERY commands which must search multiple data sets or
data bases may take some time. If you do not want to wait until
a command execution is completed, you can terminate the command
with CONTROL Y. QUERY will print < CONTROL Y > and
prompt for a new command. If CONTROL Y is used during the execution of a retrieval command (FIND,
MULTIFIND, or SUBSET), QUERY will print the number of entries found
and ask if you wish to continue searching for entries. Respond "NO"
to terminate the command. For example:
>FIND LAST-NAME IS MORGAN
USING SERIAL READ
CONTROL Y
< CONTROL Y >
2 ENTRIES HAVE QUALIFIED,
DO YOU WANT TO CONTINUE SEARCHING? NO
> |
Exiting QUERY |
|
When you are finished using QUERY, you use the QUERY EXIT
command to end QUERY execution. To terminate your MPE session, use
the MPE :BYE command. MPE responds by printing the number of seconds
of CPU time used and the number of minutes you were connected to
the system.
>EXIT
END OF PROGRAM
:BYE
CPU=6. CONNECT=6. TUE, JAN 7, 1986, 2:05 PM |
Printable version
