sqlclient
:
Executes SQL statements
sqlclient
is a simple command-line client
for use with SQL databases.
One or more SQL statements can be supplied using the sql
parameter.
The result of each statement may be one or more update counts
(for update-type statements) or tables (for query-type statements).
Tables will be written to
standard output in a format given by the ofmt
parameter.
Update results and timing information will be written to standard error.
In most cases, you will find life easier if you use either the
database's own command-line or GUI client, or, if you require STILTS-type
format conversion or post-processing, a jdbc:
-format URL
for the in
parameter of the
tpipe
or
tcopy
commands
(see Section 3.4 for more explanation of the latter).
However, this command enables you to submit multiple queries over the
same JDBC connection, including ones which do not generate a tabular
result. It may be useful if a command-line client is not available to
you for the database you are using.
This command can only be used if you have access to an SQL database via JDBC. The details of how to configure a JDBC connection to a database are discussed in Section 3.4 - obviously you will need a database to connect to and appropriate permissions on it as well as the relevant drivers.
This command is experimental, and it may be enhanced, renamed or withdrawn in future releases.