db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r901345 - /db/derby/docs/trunk/src/tools/rtoolsijcomrefshow.dita
Date Wed, 20 Jan 2010 19:34:04 GMT
Author: chaase3
Date: Wed Jan 20 19:34:03 2010
New Revision: 901345

URL: http://svn.apache.org/viewvc?rev=901345&view=rev
Log:
DERBY-4445: Document new ij SHOW FUNCTIONS command

Added to topic on SHOW command.

Patch: DERBY-4445-3.diff

Modified:
    db/derby/docs/trunk/src/tools/rtoolsijcomrefshow.dita

Modified: db/derby/docs/trunk/src/tools/rtoolsijcomrefshow.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijcomrefshow.dita?rev=901345&r1=901344&r2=901345&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijcomrefshow.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijcomrefshow.dita Wed Jan 20 19:34:03 2010
@@ -31,12 +31,14 @@
 <indexterm>SHOW ROLES command</indexterm>
 <indexterm>SHOW ENABLED_ROLES command</indexterm>
 <indexterm>SHOW SETTABLE_ROLES command</indexterm>
+<indexterm>SHOW FUNCTIONS command</indexterm>
 </keywords>
 </metadata></prolog>
 <refbody>
 <refsyn> <title>Syntax</title> <codeblock><b>SHOW
 {
    CONNECTIONS |
+   FUNCTIONS [ IN <i>schemaName</i> ] |
    INDEXES [ IN <i>schemaName</i> | FROM <i>table-Name</i> ] |
    PROCEDURES [ IN <i>schemaName</i> ] |
    ROLES |
@@ -60,7 +62,33 @@
 SAMPLE1 -        jdbc:derby:sample
 NEWDB* -        jdbc:derby:newDB;create=true
 * = current connection
-ij(NEWDB)&gt;</codeblock> <p id="showindexes"><b>SHOW INDEXES</b></p>
<p>SHOW
+ij(NEWDB)&gt;</codeblock> 
+<p id="showfunctions"><b>SHOW FUNCTIONS</b></p> <p>SHOW FUNCTIONS
displays all
+functions in the database. By default, both system functions and user-defined
+functions appear in the output.</p>
+<p>If <codeph><b>IN <i>schemaName</i></b></codeph>
is specified, then only the
+functions in the specified schema are displayed.</p>
+<p><b>Example</b></p>
+<p>If you created the TO_DEGREES function described in "CREATE FUNCTION
+statement" in the <ph conref="../conrefs.dita#pub/citref"></ph>, the output of
+the CREATE FUNCTION and SHOW FUNCTIONS commands would look something like the
+following:</p>
+<codeblock>ij&gt; <b>connect 'jdbc:derby:firstdb';</b>
+
+ij&gt; <b>CREATE FUNCTION TO_DEGREES ( RADIANS DOUBLE )</b>
+&gt; <b>RETURNS DOUBLE</b>
+&gt; <b>PARAMETER STYLE JAVA</b>
+&gt; <b>NO SQL LANGUAGE JAVA</b>
+&gt; <b>EXTERNAL NAME 'java.lang.Math.toDegrees';</b>
+0 rows inserted/updated/deleted
+ij&gt; <b>show functions in app;</b>
+FUNCTION_SCHEM|FUNCTION_NAME               |REMARKS
+-------------------------------------------------------------------------
+APP           |TO_DEGREES                  |java.lang.Math.toDegrees           
+
+1 row selected
+</codeblock>
+<p id="showindexes"><b>SHOW INDEXES</b></p> <p>SHOW
 INDEXES displays all the indexes in the database.</p> <p>If <codeph><b>IN
<i>schemaName</i></b></codeph> is
 specified, then only the indexes in the specified schema are displayed.</p> <p>If
<codeph><b>FROM <i>table-Name</i></b></codeph> is
 specified, then only the indexes on the specified table are displayed.</p> <p><b>Example</b></p>
<codeblock>ij&gt; <b>show indexes in app</b>;



Mime
View raw message