The usage of sqlskymatch
is
stilts <stilts-flags> sqlskymatch ifmt=<in-format> istream=true|false icmd=<cmds> ocmd=<cmds> omode=<out-mode> <mode-args> out=<out-table> ofmt=<out-format> ra=<expr> dec=<expr> sr=<expr> copycols=<colid-list> find=best|all ostream=true|false fixcols=none|dups|all suffix0=<label> suffix1=<label> db=<jdbc-url> user=<value> password=<value> dbtable=<table-name> dbra=<sql-col> dbdec=<sql-col> dbunit=deg|rad selectcols=<sql-cols> where=<sql-condition> [in=]<table>If you don't have the
stilts
script installed,
write "java -jar stilts.jar
" instead of
"stilts
" - see Section 3.
The available <stilts-flags>
are listed
in Section 2.1.
Parameter values are assigned on the command line as explained in Section 2.3. They are as follows:
copycols = <colid-list>
*
", which means that
all columns from the input table are included in the output.
[Default: *
]
db = <jdbc-url>
jdbc:<subprotocol>:<subname>
- the details are database- and driver-dependent.
Consult Sun's JDBC documentation and that for the particular
JDBC driver you are using for details.
Note that the relevant driver class will need to be on your
classpath and referenced in the jdbc.drivers
system property as well for the connection to be made.
dbdec = <sql-col>
dbtable
which gives the declination in degrees.
dbra = <sql-col>
dbtable
which gives the right ascension in degrees.
dbtable = <table-name>
dbunit = deg|rad
[Default: deg
]
dec = <expr>
find = best|all
best
is selected, then only the query table row
which best matches the row from the input table will be output.
If all
is selected, then any rows in the query table
which match the input table are output.
[Default: all
]
fixcols = none|dups|all
none
: columns are not renameddups
: columns which would otherwise have duplicate names in the output will be renamed to indicate which table they came fromall
: all columns will be renamed to indicate which table they came fromsuffix*
parameters.
[Default: dups
]
icmd = <cmds>
The value of this parameter is one or more of the filter commands described in Section 5.1. If more than one is given, they must be separated by semicolon characters (";"). This parameter can be repeated multiple times on the same command line to build up a list of processing steps. The sequence of commands given in this way defines the processing pipeline which is performed on the table.
Commands may alteratively be supplied in an external file,
by using the indirection character '@'.
Thus "icmd=@filename
"
causes the file filename
to be read for a list
of filter commands to execute. The commands in the file
may be separated by newline characters and/or semicolons.
ifmt = <in-format>
(auto)
(the default),
then an attempt will be
made to detect the format of the table automatically.
This cannot always be done correctly however, in which case
the program will exit with an error explaining which
formats were attempted.
[Default: (auto)
]
in = <table>
ifmt
parameter.
istream = true|false
in
table
will be read as a stream.
It is necessary to give the
ifmt
parameter
in this case.
Depending on the required operations and processing mode,
this may cause the read to fail (sometimes it is necessary
to read the input table more than once).
It is not normally necessary to set this flag;
in most cases the data will be streamed automatically
if that is the best thing to do.
However it can sometimes result in less resource usage when
processing large files in certain formats (such as VOTable).
[Default: false
]
ocmd = <cmds>
The value of this parameter is one or more of the filter commands described in Section 5.1. If more than one is given, they must be separated by semicolon characters (";"). This parameter can be repeated multiple times on the same command line to build up a list of processing steps. The sequence of commands given in this way defines the processing pipeline which is performed on the table.
Commands may alteratively be supplied in an external file,
by using the indirection character '@'.
Thus "ocmd=@filename
"
causes the file filename
to be read for a list
of filter commands to execute. The commands in the file
may be separated by newline characters and/or semicolons.
ofmt = <out-format>
(auto)
"
(the default),
then the output filename will be
examined to try to guess what sort of file is required
usually by looking at the extension.
If it's not obvious from the filename what output format is
intended, an error will result.
This parameter must only be given if
omode
has its default value of "out
".
[Default: (auto)
]
omode = <out-mode> <mode-args>
out
, which means that
the result will be written as a new table to disk or elsewhere,
as determined by the out
and ofmt
parameters.
However, there are other possibilities, which correspond
to uses to which a table can be put other than outputting it,
such as displaying metadata, calculating statistics,
or populating a table in an SQL database.
For some values of this parameter, additional parameters
(<mode-args>
)
are required to determine the exact behaviour.
Possible values are
out
meta
stats
count
cgi
discard
topcat
plastic
tosql
help=omode
flag
or see Section 5.4 for more information.
[Default: out
]
ostream = true|false
[Default: false
]
out = <out-table>
This parameter must only be given if
omode
has its default value of "out
".
[Default: -
]
password = <value>
ra = <expr>
selectcols = <sql-cols>
*
" retrieves all columns.
[Default: *
]
sr = <expr>
suffix0 = <label>
fixcols
parameter
is set so that input columns are renamed for insertion into
the output table, this parameter determines how the
renaming is done.
It gives a suffix which is appended to all renamed columns
from the input table.
[Default: _0
]
suffix1 = <label>
fixcols
parameter
is set so that input columns are renamed for insertion into
the output table, this parameter determines how the
renaming is done.
It gives a suffix which is appended to all renamed columns
from the cone result table.
[Default: _1
]
user = <value>
[Default: mbt
]
where = <sql-condition>
WHERE
keyword.
A null value indicates no additional criteria.