svn commit: r651031 - /db/derby/docs/trunk/src/ref/rrefcreatefunctionstatement.dita

[rh...@apache.org]

Author: rhillegas
Date: Wed Apr 23 13:00:30 2008
New Revision: 651031

URL: http://svn.apache.org/viewvc?rev=651031&view=rev
Log:
DERBY-3640: Beef up the CREATE TABLE section of the Reference Guide with an example of how to declare a table function.

Modified:
    db/derby/docs/trunk/src/ref/rrefcreatefunctionstatement.dita

Modified: db/derby/docs/trunk/src/ref/rrefcreatefunctionstatement.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefcreatefunctionstatement.dita?rev=651031&r1=651030&r2=651031&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefcreatefunctionstatement.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefcreatefunctionstatement.dita Wed Apr 23 13:00:30 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>