Hey, thanks. I'll look at em. On Jan 25, 2008 8:53 AM, Rick Hillegas <[EMAIL PROTECTED]> wrote: > > [EMAIL PROTECTED] wrote: > > Briggs <[EMAIL PROTECTED]> writes: > > > > > >> Hey, thanks for your reply. I am still way confused on this. And > >> trying to find examples of the SQL/JRT spec is almost impossible. I > >> am trying to make some sense of the examples of creating store > >> procedures off the http://wiki.apache.org/db-derby/DerbySQLroutines > >> wiki page with no avail. I am just trying to find the actual > >> rules/spec/documentation on doing this. > >> > > > > Don't know if it helps, but you could take a look at one of Derby's unit > > tests for procedures. For example > > > > https://svn.apache.org/repos/asf/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ProcedureTest.java > > > > > > > Hi Briggs, > > You can also take a look at the demo applications which are bundled with > Derby. These applications live in the demo subdirectory--demo is a top > level directory parallel to lib and bin. The "scores" demo gives some > examples of how to declare and use procedures and functions. If you grep > the demo tree for "ScoreTestTaking", you will see an example of how to > declare and use a procedure. The Database class in the scores demo shows > you how to: > > o Load a jar file into the database. > o Wire the jar file into the classpath. > o Declare some functions and procedures > > Hope this helps, > -Rick >
-- "Conscious decisions by conscious minds are what make reality real"
