Much of the relational capabilities of ACCENT R comes from the data manipulation power of the Interactive Command Language (ICL) commands and their optional clauses. ICL functions primarily with DB-MACH2 RDBMS and OpenVMS/RMS tables. The language has been designed so that a given command, through its clauses, can combine the functions of several commands. For example, the ALTER command’s primary purpose is to change data in fields, but through the choice of command clauses it can take on the added functions of reporting, appending data to other Data Sets (DS), and showing selected data records at the terminal. Other commands also can combine several functions.
These clauses that take on added importance in ACCENT R, were described in Chapter 7. In this chapter the description of each command includes a complete list of the clauses that can be used with that command, and any special considerations that apply when the clause is used.
Each of the ICL commands are described in this chapter in alphabetical order for easy reference.
The clauses common to several commands are:
|
To control how master and transaction records are matched in Join commands. |
|
|
To further limit records accepted for processing in Join commands. |
|
|
To limit action, in Simple commands, to specific records. |
|
|
To limit action to specific records in the Master Data Set. |
|
|
To limit action to specific records in the Transaction Data Set. |
|
|
To specify the match fields of master and transaction Data Sets when a Data Index is declared. |
|
|
To specify the match fields of master and transaction Data Sets for non-indexed processing. |
|
|
Selective Target |
To send data to output Data Sets. |
|
To replace values in fields. |
|
|
SHOWING Clause |
To print information from the master records, with an option to save shown fields in an output Data Set. |
|
To stop processing records. |
|
|
To direct output to Data Sets. |
|
|
To specify a Data Index domain. |
|
|
To specify a Process Module. |
|
|
To supply key field values for indexed processing. |
|
|
To name the transaction Data Set for Join commands. |