QUERY COMMANDS

QUERY commands are divided into seven categories according to their function. The categories can be summarized as follows:

CATEGORY	FUNCTION
Environment	Defines data base(s) and conditions for QUERY execution.
Retrieval	Locates information to be used by other commands.
Reporting	Prints specified information.
Updating	Modifies the data base(s).
Procedure	Operates on procedures in the current Proc-file.
Operation	Operates on XEQ files.
Utility	See below.

Utility commands are used for a variety of tasks. The FORM, SHOW, and VERSION commands show the current state of QUERY. The REDO and LISTREDO commands allow you to list, edit, and re-execute a previous command. The ASSIGN, RELEASE, and SETLOCKS commands operate on the data set or data base locking option. The TRANSBEGIN, TRANSEND, and TRANSMEMO commands operate on the transaction logging facility. SAVE and UNDO operate on the internal select file used by QUERY during execution. The HELP command is an interactive facility used to determine the syntax and function of QUERY commands. EXIT is used to terminate QUERY execution.

Table 2-1 “Command Categories and Functions” lists all the QUERY commands and their functions by category. The commands are discussed in detail in Section 3.

Table 2-1 Command Categories and Functions

CATEGORY	COMMAND	FUNCTION
Environ ment	`CLOSE`	Closes a data base opened with the MULTIDB command.
	`DATA-BASE=`	Specifies the primary data base, password, and access mode.
	`DATA-SETS=`	Specifies the data set list for the primary data base.
	`DBLIST=`	Informs QUERY which data bases to access for multiple data set retrieval and reporting.
	`DEFINE`	Specifies or shows the current QUERY environment for the primary data base.
	`JOIN`	Defines the compound data set used for multiple data set retrieval.
	`JOIN PROCEDURE`	Executes a JOIN procedure stored in the current Proc-file.
	`LANGUAGE=`	Shows the user language.
	`MODE=`	Specifies mode of access to the primary data base.
	`MULTIDB`	Used to open additional data bases and define or show their environment specifications.
	`OUTPUT=`	Specifies the output device.
	`PASSWORD=`	Specifies the password to access the primary data base.
	`PROC-ENTITY =`	Specifies the name of the current Proc-file.
Retrieval	`FIND`	Locates data entries in the data base.
	`FIND ALL`	Locates all entries in the data set regardless of the data item value specified.
	`FIND CHAIN`	Locates data entries from a detail data set and one or more of its corresponding master data sets.
	`FIND PROCEDURE`	Executes a FIND procedure stored in the current Proc-file.
	`MULTIFIND`	Retrieves compound data entries from a compound data set specified by the most recent JOIN command.
	`MULTIFIND ALL`	Retrieves all compound entries from a compound data set specified by the most recent JOIN command.
	`MULTIFIND PROCEDURE`	Executes a MULTIFIND procedure stored in the current Proc-file.
	`SUBSET`	Retrieves data entries from a FIND or MULTIFIND.
	`SUBSET PROCEDURE`	Executes a SUBSET procedure stored in the current Proc-file.
Updating	`UPDATE ADD`	Adds data entries to the data base.
	`UPDATE DELETE`	Deletes data entries from the data base.
	`UPDATE REPLACE`	Modifies the values of data items.
	`UPDATE PROCEDURE`	Executes an UPDATE ADD, UPDATE DELETE or UPDATE REPLACE procedure stored in the current Proc-file.
Reporting	`LIST`	Prints data entries with automatic formatting.
	`REPORT`	Reports the data entries located in the previous retrieval.
	`REPORT ALL`	Prints data item values of entries located by the last retrieval command without formatting.
	`REPORT PROCEDURE`	Executes a REPORT procedure stored in the current Proc-file.
Operation	`COMMENT`	Allows comments to be added to an XEQ file.
	`XEQ`	Executes QUERY commands from an XEQ file.
Procedure	`ALTER`	Modifies a procedure stored in the current Proc-file.
	`CREATE`	Stores a command as a procedure in the current Proc-file.
	`CREATE SPACE`	Reports the number of unused records in the current Proc-file.
	`DESTROY`	Deletes a procedure from the current Proc-file.
	`DISPLAY`	Lists a procedure stored in the current Proc-file.
	`DISPLAY LIST`	Lists the names of the procedures in the current Proc-file.
	`RENAME`	Changes the name of a procedure in the current Proc-file.
Utility	`ASSIGN`	Allows a user to enable or disable the locking option.
	`EXIT`	Terminates QUERY execution.
	`FORM`	Lists information about the data bases currently being accessed.
	`HELP`	Lists information about the function, format, and parameters of QUERY commands.
	`LISTREDO`	Displays up to the last 20 commands issued.
	`REDO`	Displays the specified command for editing and executes the edited command.
	`RELEASE`	Removes all locks set by the SETLOCKS command.
	`SAVE`	Saves the retrieved data entries in a self-describing file.
	`SETLOCKS`	Prevents automatic unlocking of a data set.
	`SHOW`	Displays the current data base list, JOIN, LOCKOPTION, and user language.
	`TRANSBEGIN`	Marks the beginning of a logical logging transaction.
	`TRANSEND`	Marks the end of a logical logging transaction.
	`TRANSMEMO`	Allows a message to be written to the log file.
	`UNDO`	Restores the entries retrieved from the previous FIND, MULTIFIND or SUBSET.
	`VERSION`	Displays the current version of QUERY and lists the IMAGE procedures and program files.

QUERY COMMANDS

Technical documentation

» Table of Contents