svn commit: r651035 - /db/derby/docs/branches/10.4/src/ref/rrefcreatefunctionstatement.dita

[rh...@apache.org]

Author: rhillegas
Date: Wed Apr 23 13:05:34 2008
New Revision: 651035

URL: http://svn.apache.org/viewvc?rev=651035&view=rev
Log:
DERBY-3640: Merge 651031 from docs trunk to 10.4 docs branch.

Modified:
    db/derby/docs/branches/10.4/src/ref/rrefcreatefunctionstatement.dita

Modified: db/derby/docs/branches/10.4/src/ref/rrefcreatefunctionstatement.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.4/src/ref/rrefcreatefunctionstatement.dita?rev=651035&r1=651034&r2=651035&view=diff
==============================================================================
--- db/derby/docs/branches/10.4/src/ref/rrefcreatefunctionstatement.dita (original)
+++ db/derby/docs/branches/10.4/src/ref/rrefcreatefunctionstatement.dita Wed Apr 23 13:05:34 2008
@@ -151,8 +151,30 @@
 <li><b>PARAMETER STYLE</b></li>
 <li><b>EXTERNAL NAME</b></li>
 </ul></p></section>
-<section><title>Example</title><codeblock><b>CREATE FUNCTION TO_DEGREES(RADIANS DOUBLE) RETURNS DOUBLE
-PARAMETER STYLE JAVA NO SQL LANGUAGE JAVA
-EXTERNAL NAME 'java.lang.Math.toDegrees'</b></codeblock></section>
+<section><title>Example of declaring a scalar function</title>
+<codeblock><b>
+CREATE FUNCTION TO_DEGREES
+( RADIANS DOUBLE )
+RETURNS DOUBLE
+PARAMETER STYLE JAVA
+NO SQL LANGUAGE JAVA
+EXTERNAL NAME 'java.lang.Math.toDegrees'
+</b></codeblock>
+</section>
+<section><title>Example of declaring a table function</title>
+<codeblock><b>
+CREATE FUNCTION PROPERTY_FILE_READER
+( FILENAME VARCHAR( 32672 ) )
+RETURNS TABLE
+  (
+     KEY_COL     VARCHAR( 10 ),
+     VALUE_COL VARCHAR( 1000 )
+  )
+LANGUAGE JAVA
+PARAMETER STYLE DERBY_JDBC_RESULT_SET
+NO SQL
+EXTERNAL NAME 'vtis.example.PropertyFileVTI.propertyFileVTI'
+</b></codeblock>
+</section>
 </refbody>
 </reference>