Go to the first, previous, next, last section, table of contents.

Query

What's That?

Query (as well as its documentation :-) is in a very early beta stage. Some features may be buggy (but non destructive) or incompletely implemented.

QUERY is a command used to extract various data. It is especially useful if you are using Ultimedia Mail/Lite as your mail reader or IBM Global Network as your Internet provider. It was created to simply obtain data that were concealed or not otherwise directly available.

If you use ATT Global Network as your Internet provider, you can check your connect time (it does take into account the minimum 35 seconds connect time) as well as review the various messages you may have received when you dial in. You may have to increase your Connect.Log size (see the Logging page of your Dialer's setting notebook) if you want to be able to query connection statistics for more than one month or two. (50K looks like a reasonable figure as it can hold something like three months of data...) 

   QUERY CONNECT TIME
   QUERY THIS YEAR CONNECT TIME FOR USER1
   QUERY DETAILED NOVEMBER CONNECT TIME FOR USER1 USER2
   QUERY LAST CONNECT MESSAGE

If you use Ultimedia Mail/Lite as your mail reader, you can search your mail folders for messages. 

   QUERY MAIL FOR USER1 IN INBOX WHERE SUBJECT CONTAINS "PAGING"

You can also query numerous data, such as system date or time, loaded drivers, etc. 

   QUERY DATE
   QUERY DISK
   QUERY OS VERSION
   QUERY PICTURE DIMENSION FOR header.gif night.jpg
   ...

The complete supported command list follows.

Where the optional elements values are defined as:

timeframe
[THIS | LAST] (YEAR | MONTH | monthname) ['S]
monthname
JANuary | FEBruary | MARch | APRil | MAY | JUNe | JULy | AUGust | SEPtember | OCTober | NOVember | DECember
foldername
name | "name" | * | foldername, foldername
condition
element operator value [(OR | AND) condition]
element
FROM | TO | SUBJECT | SENDER [['S] DOMAIN]
unit
* | letter[:] | unit unit
component
REXX | JAVA | OS

Installation

Installing Query is very simple: just copy QUERY.CMD somewhere along your PATH and REXXVIO.DLL somewhere along your LIBPATH.

If REXXVIO.DLL is currently in use, close ALL your OS/2 windowed or fullscreen sessions, and open a bare OS/2 windowed session (that is, one not starting CmdShl or Fl). You can then replace REXXVIO.DLL from this session.

If you were using a previous version of MLRXSHL, execute the following code from an OS/2 command prompt, to allow the new functions defined in REXXVIO to be registered: 

   rexxtry call VioDropFuncs

If you want to be able to query the system memory, you will need the RXU library, available from e.g. Hobbes.nmsu.edu. If you use an old OS/2 release that has no support for long files (i.e., files that are bigger than 2GB), overwrite REXXVIO.DLL with REXXVIO.OLD beforehand.

Starting Query

                        +--Date--+
        +---------------+--Time--+------------------------------+
        +------------------DISK-+----------+--------------------+
        |                       +-unit ...-+                    |
        +------------------PICTure-DIMension-FOR-file ...-------+
        +------------------SYStem---+-DEVices-+-----------------+
        |                           +-DRIVERS-+                 |
        |                           +--IRQs---+                 |
        |                           +-MEMory--+                 |
        +------------------PROCess-ID---------------------------+
QUERY --+------------------DIRectory-STACK----------------------+--|
        +------------------OS--+---------+----------------------+
        |                      +-Version-+                      |
        +----------------+-JAVA-+----Version--------------------+
        |                +--OS--+                               |
        |                +-REXX-+                               |
        +----------------+------+-NEWS-+---------+--------------+
        |                +-LAST-+      +-REFRESH-+              |
        ++------++-----------++CONNECT-+MESSAGE++--------------++
         +-THIS-++---MONTH---+|        +-TIME--++-FOR user ...-+|
         +-LAST-++---YEAR----+|                                 |
                 +--JANuary--++MAIL+--------++------++---------++
                 :           :     +FROM ...++IN ...++WHERE ...+
You just have to specify the upper-cased part of an argument to design it. For example "QUERY DATE" and "QUERY D" are equivalent.

The "QUERY SYSTEM MEMORY" command requires RXU.DLL, which is not included in this package. You can find it from your favorite FTP site. If RXU is missing, you cannot use this command, but all others are still available.

Environment variables

Query recognizes the following environment variables: 

   HELP.COMMAND
   HELP.SWITCHES

If one or more of those environment variables are not defined, they are silently ignored. (They are used to define an optional external help subsystem.)

HELP.COMMAND

If this environment variable is defined, Query will not use its build-in help messages. Instead, it will call the script/application defined by this variable.

For example, if HELP.COMMAND is defined as: 

   SET HELP.COMMAND=ECHO Help for

Issuing "QUERY /?" will give: 

   Help for QUERY /?

(In other words, the command is displayed back to the user.)

The syntax of the call is the following: 

   call %HELP.COMMAND% QUERY <args>

where <args> being the argument(s) given to the command by the user.

HELP.SWITCHES

If this environment variable is defined, it contains a space-delimited list of switches used to obtain help from the command.

For example: 

   SET HELP.SWITCHES=/? -h

If this environment variable is not defined, Query assumes "/?" as its value.

Go to the first, previous, next, last section, table of contents.