/usr/share/doc/stilts/sun256/sqlupdate-usage.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 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 | <html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="sun-style.css">
<title>Usage</title>
</head>
<body>
<hr>
<a href="secB.19.2.html">Next</a> <a href="sqlupdate.html">Previous</a> <a href="sqlupdate.html">Up</a> <a href="index.html">Contents</a> <br> <b>Next: </b><a href="secB.19.2.html">Examples</a><br>
<b>Up: </b><a href="sqlupdate.html">sqlupdate: Updates values in an SQL table</a><br>
<b>Previous: </b><a href="sqlupdate.html">sqlupdate: Updates values in an SQL table</a><br>
<hr>
<h3><a name="sqlupdate-usage">B.19.1 Usage</a></h3>
<p>The usage of <code>sqlupdate</code> is
<pre>
stilts <stilts-flags> sqlupdate db=<jdbc-url> user=<value> password=<value>
select=<select-stmt> assign=<col>=<expr>
progress=true|false
</pre>
If you don't have the <code>stilts</code> script installed,
write "<code>java -jar stilts.jar</code>" instead of
"<code>stilts</code>" - see <a href="invoke.html">Section 3</a>.
The available <code><stilts-flags></code> are listed
in <a href="stilts-flags.html">Section 2.1</a>.
For programmatic invocation, the Task class for this
command is <code>uk.ac.starlink.ttools.task.SqlUpdate</code>.
</p>
<p>Parameter values are assigned on the command line
as explained in <a href="task-args.html">Section 2.3</a>.
They are as follows:
</p>
<p>
<dl>
<dt><strong><code>assign = <col>=<expr></code> <em>(Assignment[])</em></strong></dt>
<dd>Assigns new values for a given column.
The assignment is made in the form
<code><colname>=<expr></code>
where <code><colname></code> is the name of a column
in the SQL table and
<code><expr></code> is the text of an expression using
STILTS's expression language, as described in <a href="jel.html">Section 10</a>.
SQL table column names or $ID
identifiers may be used as variables in the usual way.
<p>This parameter may be supplied more than once to effect
multiple assignments, or multiple assignments may be made
by separating them with semicolons in the value of this
parameter.
</p>
</dd>
<dt><strong><code>db = <jdbc-url></code> <em>(<a href="http://docs.oracle.com/javase/6/docs/api/java/sql/Connection.html">Connection</a>)</em></strong></dt>
<dd>URL which defines a connection to a database.
This has the form
<code>jdbc:<subprotocol>:<subname></code>
- 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 <code>jdbc.drivers</code>
system property as well for the connection to be made.
</dd>
<dt><strong><code>password = <value></code> <em>(String)</em></strong></dt>
<dd>Password for logging in to SQL database.
</dd>
<dt><strong><code>progress = true|false</code> <em>(Boolean)</em></strong></dt>
<dd>If true, a spinner will be drawn on standard error
which shows how many rows have been updated so far.
<p>[Default: <code>true</code>]
</p>
</dd>
<dt><strong><code>select = <select-stmt></code> <em>(String)</em></strong></dt>
<dd>Gives the full text (including "<code>SELECT</code>")
of the SELECT statement to identify which rows undergo
updates.
</dd>
<dt><strong><code>user = <value></code> <em>(String)</em></strong></dt>
<dd>User name for logging in to SQL database.
Defaults to the current username.
<p>[Default: <code>buildd</code>]
</p>
</dd>
</dl>
</p>
<hr><a href="secB.19.2.html">Next</a> <a href="sqlupdate.html">Previous</a> <a href="sqlupdate.html">Up</a> <a href="index.html">Contents</a> <br> <b>Next: </b><a href="secB.19.2.html">Examples</a><br>
<b>Up: </b><a href="sqlupdate.html">sqlupdate: Updates values in an SQL table</a><br>
<b>Previous: </b><a href="sqlupdate.html">sqlupdate: Updates values in an SQL table</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>
|