HP 3000 Manuals HP 3000 Manuals
USING QUERY IN SESSION
When entering information in session mode, you can delete one or more
previously typed characters by entering a CONTROL H character for each
character you want to delete. You can delete the current line with
CONTROL X. Control characters are entered by pressing the control key
while pressing the appropriate letter key.
Running QUERY
The following illustrates the procedure to initiate a QUERY session.
RETURN
:HELLO MANAGER.DATAMGT,ACCOUNTS
HP3000 / MPE V G.A2.A0 (BASE G.A2.A0). MON, MAR 23, 1987, 11:41 AM
:RUN QUERY.PUB.SYS
HP32216C.00.08 QUERY/3000 MON, MAR 23, 1987, 11:42 AM
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 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