/usr/share/doc/stilts/sun256/secB.17.2.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 | <html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="sun-style.css">
<title>Examples</title>
</head>
<body>
<hr>
<a href="sqlskymatch.html">Next</a> <a href="sqlclient-usage.html">Previous</a> <a href="sqlclient.html">Up</a> <a href="index.html">Contents</a> <br> <b>Next: </b><a href="sqlskymatch.html">sqlskymatch:
Crossmatches table on sky position against SQL table</a><br>
<b>Up: </b><a href="sqlclient.html">sqlclient:
Executes SQL statements</a><br>
<b>Previous: </b><a href="sqlclient-usage.html">Usage</a><br>
<hr>
<h3><a name="secB.17.2">B.17.2 Examples</a></h3>
<p>Here are some examples of <code>sqlclient</code>:
<dl>
<dt><strong><pre>
stilts -classpath lib/drivers.jtds-1.1.jar \
-Djdbc.drivers=net.sourceforge.jtds.jdbc.Driver \
-Djava.net.preferIPv4Stack=true \
sqlclient \
db='jdbc:jtds:sqlserver://amenhotep:1433/twomass' \
user='guest1' \
ofmt=csv-nohead \
sql='SET SHOWPLAN_TEXT ON' \
sql='SELECT ra,dec FROM twomass_psc WHERE ra BETWEEN 21.7 AND 21.8 \
AND dec BETWEEN 9.1 AND 9.12'
</pre></strong></dt>
<dd>This sends two commands to a SQL Server database; the first one
(SET SHOWPLAN...) sets a flag which causes the DB to return an
execution plan rather than the result for subsequent queries,
and the second makes the query itself.
Since the password is not provided on the command line, a prompt
for it will be issued before execution.
The result is SQL Server's execution plan for the SELECT statement
expressed as a headerless comma-separated value table sent to the terminal.
CSV is chosen for the output format since it does not truncate wide columns.
</dd>
</dl>
</p>
<hr><a href="sqlskymatch.html">Next</a> <a href="sqlclient-usage.html">Previous</a> <a href="sqlclient.html">Up</a> <a href="index.html">Contents</a> <br> <b>Next: </b><a href="sqlskymatch.html">sqlskymatch:
Crossmatches table on sky position against SQL table</a><br>
<b>Up: </b><a href="sqlclient.html">sqlclient:
Executes SQL statements</a><br>
<b>Previous: </b><a href="sqlclient-usage.html">Usage</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>
|