stilts-doc 3.1.2-2 / usr / share / doc / stilts / sun256 / sqlclient-usage.html

This file is indexed.

/usr/share/doc/stilts/sun256/sqlclient-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
<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.17.2.html">Next</a> <a href="sqlclient.html">Previous</a> <a href="sqlclient.html">Up</a> <a href="index.html">Contents</a> <br> <b>Next: </b><a href="secB.17.2.html">Examples</a><br>
       <b>Up: </b><a href="sqlclient.html">sqlclient:
         Executes SQL statements</a><br>
       <b>Previous: </b><a href="sqlclient.html">sqlclient:
         Executes SQL statements</a><br>
      
      <hr>
      <h3><a name="sqlclient-usage">B.17.1 Usage</a></h3>
      <p>The usage of <code>sqlclient</code> is
         <pre>
   stilts &lt;stilts-flags&gt; sqlclient db=&lt;jdbc-url&gt; user=&lt;value&gt; password=&lt;value&gt;
                                   sql=&lt;sql&gt; ofmt=&lt;out-format&gt;
</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>&lt;stilts-flags&gt;</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.SqlClient</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>db = &lt;jdbc-url&gt;</code> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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:&lt;subprotocol&gt;:&lt;subname&gt;</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>ofmt = &lt;out-format&gt;</code> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<em>(String)</em></strong></dt>
            <dd>Specifies the format in which the output table will be written
               (one of the ones in <a href="outFormats.html">Section 5.2.2</a> - matching is
               case-insensitive and you can use just the first few letters).
               If it has the special value
               "<code>(auto)</code>"
               (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.
               
               <p>[Default: <code>text</code>]
               </p>
            </dd>
            <dt><strong><code>password = &lt;value&gt;</code> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<em>(String)</em></strong></dt>
            <dd>Password for logging in to SQL database.
               
            </dd>
            <dt><strong><code>sql = &lt;sql&gt;</code> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<em>(String)</em></strong></dt>
            <dd>Text of an SQL statement for execution.
               This parameter may be repeated, or statements may be
               separated by semicolon ("<code>;</code>") characters.
               
            </dd>
            <dt><strong><code>user = &lt;value&gt;</code> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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.17.2.html">Next</a> <a href="sqlclient.html">Previous</a> <a href="sqlclient.html">Up</a> <a href="index.html">Contents</a> <br> <b>Next: </b><a href="secB.17.2.html">Examples</a><br>
       <b>Up: </b><a href="sqlclient.html">sqlclient:
         Executes SQL statements</a><br>
       <b>Previous: </b><a href="sqlclient.html">sqlclient:
         Executes SQL statements</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>

APT Browse - Built by Thomas Orozco.