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>]
-o
flag is specified,
output is <out-table>
;
otherwise, or if <out-table>
has the special
value "-
", it's streamed to standard output.
The output format is named using the -ofmt
flag
(see Section 3.2); 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
).
If you give an unknown output format (e.g. -ofmt help
)
then a list of all known formats will be printed.
-tosql <jdbc-url> [-user <username>]
[-password <password>]
-Djdbc.drivers
set as usual
(see Section 2.6).
You can specify your SQL connection username and password or not -
you will be prompted on the terminal if they are required.
-stats
-meta
-count
-topcat
If no mode specifier is given, -write
is assumed.
This means that with no mode specifier, the processed table is written to
standard output in text
format.