Eloquence Query Manual
[1] [2]
#
*
+
-
/
=
>
ADD adding entries adding entries (using forms) addition ADD...FROM... AND automatic master
BREAK ON [1] [2] BREAK ON...TOTAL BREAK ON...TOTAL... breaking a listing into groups
changing a data entry changing databases changing passwords closing the database columnar format command entry softkeys command syntax computing with numeric data items CONSOLE Control Number [1] [2] Creating a DO file Creating a FORM Creating a REPORT subprogram Creating a Workfile
data chain data entry data item data path data set adding entries adding entries (using forms) automatic master deleting entries deleting key items detail data set manual master master data set replacing entries threading multiple data sets database adding data entries adding entries adding entries (using forms) changing databases closing the database data chain data entry data item data path data set database schema deleing key items deleting entries information key item modifying password [1] [2] replacing entries schema specifying DATABASE [1] [2] database schema Date Conversion DELETE [1] [2] deleting entries deleting key items detail data set DISPLAY division DO [1] [2] [3]
entering commands equal to function error messages EXIT [1] [2] [3]
finding entries finding entries in multiple data sets finding entries in one data set FIND...FOR... [1] [2] formatting the report breaking a listing into groups subtotaling data items totaling data items
generating reports greater than
heading How to Create Files
INFO [1] [2] information item list item name
key item [1] [2] [3] deleting
label (softkey) leaving Query less than linear format LINEAR LIST [1] [2] link data chain data path key item LIST [1] [2] listing the workfile listing the workfile in columnar format listing the workfile in linear format loading Query logical AND logical OR
manual master master data set automatic master manual master math operations messages modifying the database adding entries deleting entries deleting key items replacing entries multiplication
not equal to function
OR output device OUTPUT TO [1] [2]
password [1] [2] [3] POS position function prewritten procedure PRINTER printer number procedure
removing a data entry REPLACE [1] [2] replacing entries reporting creating page headings creating subtotals formatting totaling data items RUN [1] [2] running Query
schema password search expression [1] [2] set name softkey label softkeys SORT BY [1] [2] sort list sorting the workfile specifying a database specifying a workfile specifying the output device spool file starting Query STDERR STDOUT stopping Query subtotals subtraction syntax
temporary storage terminating Query THREAD [1] [2] threading data sets TOTAL
using softkeys using the FIND softkey
WORKFILE workfile wrap around