IDENTIFYING THE QUERY ENVIRONMENT [ QUERY/V Reference Manual ] MPE/iX 5.0 Documentation
QUERY/V Reference Manual
IDENTIFYING THE QUERY ENVIRONMENT
The three commands used to open data bases are DATA-BASE=, DEFINE, and
MULTIDB. All of these commands prompt for various environment
specifications with two greater than symbols (>>).
The DATA-BASE= or the DEFINE command is used to open the primary data
base. You can use either command, but only one data base can be the
primary data base at any time. You use the DATA-BASE= command to open
the primary data base if you only want to open a data base. The
DATA-BASE= command prompts for the password and access mode. You must
specify a password (if the data base has security) and an access mode.
>DATA-BASE=ORDERS
PASSWORD = >>CLERK
MODE = >>5
>
You use the DEFINE command to open the primary data base if you want to
open a data base and specify a data set list, procedure file, and/or
output device. You can respond to these additional prompts, or you can
press RETURN to display the next prompt. If you press RETURN at the
OUTPUT prompt, the default output device is your terminal. You can also
set the data set list, procedure file, and output device later by using
the the DATA-SETS=, PROC-FILE=, or OUTPUT= commands, respectively.
>DEFINE
DATA-BASE = >>ORDERS
PASSWORD = >>CLERK
MODE = >>1
DATA-SETS = >>CUSTOMER
PROC-FILE = >>MANPROC
OUTPUT = TERM
OUTPUT = >>RETURN
>
After you have opened a primary data base using the DATA-BASE= or the
DEFINE command, you can open additional data bases using the MULTIDB
command. The MULTIDB command prompts for the password, access mode, and
data set list. You can press RETURN at the DATA-SET prompt. You can
open multiple data bases with one MULTIDB command. To terminate the
command, press RETURN at the DATA-BASE= prompt.
>MULTIDB
DATA-BASE = >>CITY
PASSWORD = >>OPEN
MODE = >>3
DATA-SETS = >>DISTRICT
DATA-BASE = >>STATE
PASSWORD = >>USE
MODE = >>3
DATA-SETS = >>COUNTY
DATA-BASE = >>RETURN
>
Both the DEFINE and MULTIFIND commands can also be used to display the
current environment specifications. Each of the environment prompts can
also be used as a command to change the specifications. For information
on the function of each prompt, refer to the corresponding command.
MPE/iX 5.0 Documentation