Printer Friendly Reporting, Viewing and Storing Data Reporting

Three commands are available which allow one to select portions of the data and write it to a post-processing file, an output file, or to the screen. Perhaps the easiest command to explain is the REPORT command, which produces a formatted output file report. The format of this command is:


     REPORT, DATA,  -OPTIONS

The form of the REPORT command depends upon the original command that placed the user here. Often only REPORT is necessary. Some original commands allow for data and options to be specified on the REPORT command. These details will be discussed with the original command.

The next of these is:


     VIEW, CS(1), CS(2), .....  -OPTIONS

and the available options are:


     -HARD

     -RECORD, BEG_RNUM, END_RNUM

     -HEADING, HEAD

     -MAG_USE

This command offers the user the opportunity to view the selected data at the terminal, or, if the -HARD option is specified, the results will be written to the output file. The data viewed is defined by the column selectors CS(1), CS(2),.. If no column selectors are specified, MOSES will prompt the user for all required data.

The STORE command is used to store the selected data in a "table". The result here is much the same as what you get in the &TABLE menu, i.e. either a CSV or HTML table. The format of the command is:


     STORE,  CS(1), CS(2), .....  -OPTIONS

and the available options are:


     -RECORD, BEG_RNUM, END_RNUM

     -MAG_USE

     -HEADING, HEAD

     -TITLE, NCOL(1), CT(1), .... NCOL(n), CT(n)

     -H_SKIP, YES_NO

     -BOLD, YES_NO

     -ROW_SHADE, YES_NO

     -EXTR_SHADE, COL_SEL(1), COL_SEL(2), .....

     -V_LINES, COL_SEL(1), COL_SEL(2), .....

with the exception of -RECORD and -MAG_USE these option work exactly as documented with &TABLE.


Ultramarine, Inc. | Suite 325 | 3100 S. Gessner | Houston, Texas 77063 | (713)975-8146

Next

Copyright(C) 1996-2008 Ultramarine,Inc.