ENGLISH (ReTrieve) Commands [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== ENGLISH (ReTrieve) Commands ======

==== SORT and LIST ====

The LIST processor allows you to generate output based on sort and selection criteria.  Please refer to your OpenInsight guides for the syntax of the LIST command.

 

The SORT command is identical to the LIST command.  Additionally, the SORT command will sort the selected data by item name if no other sort criteria is specified.

  

==== SSELECT and SELECT ====

The SELECT processor allows you to generate a 'select list' based on selection criteria.  Please refer to your OpenInsight guides for the syntax of the SELECT command.

 

The SSELECT command is identical to the SELECT command.  Additionally, the SSELECT command will sort the selected data by item name if no other sort criteria is specified.

 

The select list generated by SELECT or SSELECT is only valid until the next executed command.  If you wish to "preserve" the select list for future use, please see the SAVE.LIST command.

 

When your select list is “active”, the command prompt will change from “>” to “>>”.  As long as “>>” is your command prompt, you have an active select list.  This list will remain active until it is “consumed” by a process that can use an active select list (such as ED, LIST, etc.) or until the CLEARSELECT command is issued.

==== QSELECT ====

The QSELECT command has the following syntax:

 

QSELECT {DICT} <filename> <itemid> {<itemid><itemid>…*} {(<fieldno>}

 

This command creates a select list from the specified filename and itemname(s) entered.  Each attribute and value within the item(s) is used to build the select list.  You may specify one or more items, or an “*” for all items in the file.

 

If you specify the optional <fieldno>, then the specified field, and any contained values, is used to build the select list.  

 

==== COUNT ====

The COUNT command will count the number of items in the specified table, after applying any optional selection criteria.  The syntax for the COUNT command is:

 

COUNT {DICT} <filename> {<selection criteria>}

 

For example, to count all the items in file EMPLOYEES, you may issue the following command:

 

COUNT EMPLOYEES

 

To count all the employees in group "A", you may issue the following command:

 

COUNT EMPLOYEES WITH GROUP = "A"

 

==== SUM ====

The SUM command has the following syntax:

 

SUM {DICT} <filename> <fieldname> {<fieldname>}

 

It will display the sum of each of the specified columns.