Next Previous Up Contents
Next: Miscellaneous Flags
Up: Arguments
Previous: Filter Specifiers

B.3.3.3 Mode Specifier

The mode specifier determines what happens to the processed table when it reaches the output end of the pipeline. Only one of the following should be specified:

-write [-ofmt <out-format>] [-o <out-table>]
A new table is written. If the -o flag is specified, it's written to the named file, otherwise it's streamed to standard output. The output format is named using the -ofmt flag; if not supplied, an attempt is made to guess the format from the destination name. If neither -o nor -ofmt is specified, it's written in formatted text format to standard output (equivalent to -o - -ofmt text).
-tosql <jdbc-url> [-user <username>] [-password <password>]
A new table is written to an SQL database. You need the appropriate JDBC drivers and -Djdbc.drivers set as usual. You can specify your SQL connection username and password or not - you will be prompted on the terminal if they are required.
-stats
Calculates and displays statistics (mean, standard deviation, minimum, maximum and number of good columns) for each column in the input table.
-meta
Prints to standard output the table metadata: parameters and column names.
-count
Counts the number of rows and columns and writes the answers to standard output.

If no mode specifier is given, -write is assumed.


Next Previous Up Contents
Next: Miscellaneous Flags
Up: Arguments
Previous: Filter Specifiers

STIL - Starlink Tables Infrastructure Library
Starlink User Note 252
STIL web page: http://www.starlink.ac.uk/stil/
Author email: m.b.taylor@bristol.ac.uk
Starlink: http://www.starlink.ac.uk/