/usr/share/doc/stilts/sun256/sqlclient.html is in stilts-doc 3.1.2-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 | <html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="sun-style.css">
<title>sqlclient:
Executes SQL statements
</title>
</head>
<body>
<hr>
<a href="sqlclient-usage.html">Next</a> <a href="server-client-examples.html">Previous</a> <a href="cmdUsage.html">Up</a> <a href="index.html">Contents</a> <br> <b>Next: </b><a href="sqlclient-usage.html">Usage</a><br>
<b>Up: </b><a href="cmdUsage.html">Command Reference</a><br>
<b>Previous: </b><a href="server-client-examples.html">Client Examples</a><br>
<hr>
<hr>
<h2><a name="sqlclient">B.17 <code>sqlclient</code>:
Executes SQL statements</a></h2>
<p><code>sqlclient</code> is a simple command-line client
for use with SQL databases.
One or more SQL statements can be supplied using the <code>sql</code>
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 <code>ofmt</code> parameter.
Update results and timing information will be written to standard error.
</p>
<p>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 <code>jdbc:</code>-format URL
for the <code>in</code> parameter of the
<a href="tpipe.html"><code>tpipe</code></a> or
<a href="tcopy.html"><code>tcopy</code></a> commands
(see <a href="jdbcConfig.html">Section 3.4</a> 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.
</p>
<p>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 <a href="jdbcConfig.html">Section 3.4</a> - obviously
you will need a database to connect to and appropriate permissions
on it as well as the relevant drivers.
</p>
<p><strong>This command is experimental</strong>,
and it may be enhanced, renamed or withdrawn in future releases.
</p>
<ul>
<li><a href="sqlclient-usage.html">B.17.1 Usage</a></li>
<li><a href="secB.17.2.html">B.17.2 Examples</a></li>
</ul>
<hr><a href="sqlclient-usage.html">Next</a> <a href="server-client-examples.html">Previous</a> <a href="cmdUsage.html">Up</a> <a href="index.html">Contents</a> <br> <b>Next: </b><a href="sqlclient-usage.html">Usage</a><br>
<b>Up: </b><a href="cmdUsage.html">Command Reference</a><br>
<b>Previous: </b><a href="server-client-examples.html">Client Examples</a><br>
<hr><i>STILTS - Starlink Tables Infrastructure Library Tool Set<br>Starlink User Note256<br>STILTS web page:
<a href="http://www.starlink.ac.uk/stilts/">http://www.starlink.ac.uk/stilts/</a><br>Author email:
<a href="mailto:m.b.taylor@bristol.ac.uk">m.b.taylor@bristol.ac.uk</a><br>Mailing list:
<a href="mailto:topcat-user@jiscmail.ac.uk">topcat-user@jiscmail.ac.uk</a><br></i></body>
</html>
|