QUERY/iX Reference Manual > Chapter 2 USING QUERY/iX

USING QUERY IN SESSION MODE

	MPE documents
	Complete PDF
	Table of Contents

	E0300 Edition 7 ♥
	E1098 Edition 6

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
  >


  :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

Chapter 2 USING QUERY/iX

USING QUERY IN JOB MODE