NAME

       stilts-sqlclient - Executes SQL statements

SYNOPSIS

       stilts sqlclient [db=<jdbc-url>] [user=<value>] [password=<value>] [sql=<sql>] [ofmt=<out-format>]

DESCRIPTION

       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 SUN/256 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 SUN/256 - 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.

OPTIONS

       db=<jdbc-url>
              URL which defines a connection to a database. This has the form 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.

       user=<value>
              User name for logging in to SQL database. Defaults to the current username.

       password=<value>
              Password for logging in to SQL database.

       sql=<sql>
              Text of an SQL statement for execution. This parameter may  be  repeated,  or  statements  may  be
              separated by semicolon (";") characters.

       ofmt=<out-format>
              Specifies  the  format  in  which  the  output table will be written (one of the ones in SUN/256 -
              matching is case-insensitive and you can use just the first few letters). If it  has  the  special
              value  "(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.

SEE ALSO

       stilts(1)

       If the package stilts-doc is installed, the full documentation SUN/256 is available in HTML format:
       file:///usr/share/doc/stilts-doc/sun256/index.html

VERSION

       STILTS version 3.2-debian

       This  is the Debian version of Stilts, which lack the support of some file formats and network protocols.
       For differences see
       file:///usr/share/doc/stilts/README.Debian

AUTHOR

       Mark Taylor (Bristol University)

                                                    Mar 2017                                 STILTS-SQLCLIENT(1)