[ http://issues.apache.org/jira/browse/DERBY-382?page=comments#action_12314382 ]
Jean T. Anderson commented on DERBY-382: ---------------------------------------- Here's a simple example for the "CREATE FUNCTION" statement in http://incubator.apache.org/derby/docs/ref/rrefcreatefunctionstatement.html $ cat MyFuncs.java import java.sql.*; import java.util.*; public class MyFuncs { public static int myAdd(int val1, int val2) { int retval = val1 + val2; return retval; } } $ javac MyFuncs.java $ java org.apache.derby.tools.ij ij> connect 'jdbc:derby:testdb;create=true'; ij> create function myAdd (val1 integer, val2 integer) returns integer language java parameter style java no sql external name 'MyFuncs.myAdd'; 0 rows inserted/updated/deleted ij> values myAdd(5,4); 1 ----------- 9 1 row selected > Doc Review: Derby Reference Manual > ---------------------------------- > > Key: DERBY-382 > URL: http://issues.apache.org/jira/browse/DERBY-382 > Project: Derby > Type: Improvement > Components: Documentation > Environment: all > Reporter: Jeff Levitt > Priority: Minor > Fix For: 10.1.1.0 > > This issue tracks comments for the Derby Reference Manual. The deadline for > posting comments is Tuesday, June 28, noon Pacific time. > Some guidelines to follow when posting comments to this issue are: > - Try to make clear and concise comments about what you want changed whenever > possible. Provide concrete comments that say "Please change <original> to > <modified>" instead of generic comments like "This section needs to be > rewritten." > - If you're reviewing the HTML Files copy, include the URL for the page in > the review comment. Obtain the URL like this: > * highlight the topic in the left frame > * right click > * choose "Properties" > * copy and paste the address in the pop up box. > - If you're reviewing the PDF copy, in the review comment: > * Include the page number for the PDF, and indicate whether the number is > the PDF sheet number or the printed page number. > * Include the title of the section that the problem occurs in. If it's in > a subsection, try to include the hierarchy of titles. > - Please don't review the HTML Book copy -- it'll be time consuming to match > up that copy with the underlying DITA source. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
