USING QUERY IN SESSION MODE

When entering information in session mode, you can delete one or more previously typed characters by entering a CONTROLH character for each character you want to delete. You can delete the current line with CONTROLX. 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/V  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 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