db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "DerbySQLroutines" by jeanTanderson
Date Fri, 09 Jun 2006 20:02:03 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by jeanTanderson:
http://wiki.apache.org/db-derby/DerbySQLroutines

The comment on the change is:
added some anchors

------------------------------------------------------------------------------
  [[TableOfContents(2)]]
  
  == Functions vs. Procedures ==
+ [[Anchor(FunctionsVsProcedures)]]
  
  There is overlap between SQL Functions and Procedures, 
  but each can also do things the other cannot and the syntax for invoking each is different.
@@ -46, +47 @@

  ||Execute in a SQL expression||no||yes||
  
  == Creating Functions ==
+ [[Anchor(Creating Functions)]]
  
  The [http://db.apache.org/derby/docs/dev/ref/rrefcreatefunctionstatement.html Reference
Guide] provides the syntax for creating functions.
  
@@ -65, +67 @@

   * [http://mail-archives.apache.org/mod_mbox/db-derby-user/200501.mbox/%3c41DAC70D.7000002@debrunners.com%3e
A function that converts a Timestamp to its corresponding Long value using Java]
  
  == Creating Procedures ==
+ [[Anchor(Creating Procedures)]]
  
  The [http://db.apache.org/derby/docs/dev/ref/rrefcreateprocedurestatement.html Reference
Guide] provides the syntax for creating procedures.
  
@@ -132, +135 @@

   * Returning less !ResultSets than defined by the DYNAMIC RESULT SETS clause is ok, only
fill in the number of arrays you need. So in this example to only return one !ResultSet either
just set data1[0] to the !ResultSet or data2[0] to the !ResultSet. Remember the order returned
through !CallableStatement is driven by the order of creation, not the order of the method's
parameters.
  
  == The power of Java in SQL ==
+ [[Anchor(ThePowerOfJavaInSql)]]
+ 
  The ability to write functions and procedures in Java brings the complete set of Java
  apis into your SQL environment as server side logic. A function or procedure may call
  any of the standard Java libraries, any of the standard Java extensions, or other third

Mime
View raw message