db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r1701708 - /db/derby/docs/trunk/src/tools/rtoolsoptsimplejson.dita
Date Mon, 07 Sep 2015 22:06:38 GMT
Author: rhillegas
Date: Mon Sep  7 22:06:38 2015
New Revision: 1701708

URL: http://svn.apache.org/r1701708
Log:
DERBY-6829: Document more functions introduced by the simpleJson optional tool; commit derby-6829-02-aa-documentMoreFunctions.diff.

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

Modified: db/derby/docs/trunk/src/tools/rtoolsoptsimplejson.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsoptsimplejson.dita?rev=1701708&r1=1701707&r2=1701708&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsoptsimplejson.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsoptsimplejson.dita Mon Sep  7 22:06:38 2015
@@ -64,6 +64,29 @@ into a JSONArray value.</li>
 </ul>
 
 <p>
+These functions have the following signatures:
+</p>
+
+<codeblock><b>
+create function readArrayFromString( document varchar( 32672 ) )
+returns JSONArray
+language java parameter style java contains sql
+external name 'org.apache.derby.optional.api.SimpleJsonUtils.readArrayFromString'
+
+create function readArrayFromFile
+( fileName varchar( 32672 ), characterSetName varchar( 100 ) )
+returns JSONArray
+language java parameter style java contains sql
+external name 'org.apache.derby.optional.api.SimpleJsonUtils.readArrayFromFile'
+
+create function readArrayFromURL
+( urlString varchar( 32672 ), characterSetName varchar( 100 ) )
+returns JSONArray
+language java parameter style java contains sql
+external name 'org.apache.derby.optional.api.SimpleJsonUtils.readArrayFromURL'
+</b></codeblock>
+
+<p>
 These functions can then be used to turn JSON documents into tabular data sets using
 <i>org.apache.derby.optional.api.SimpleJsonVTI</i>. That class is documented
in Derby's public api too. Using this technique,
 you can join JSON data with other relational data. You can also exploit this technique



Mime
View raw message