[Db-derby Wiki] Update of "SqlPsmSupport" by DanDebrunner

[Apache Wiki <wi...@apache.org>]

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 DanDebrunner:
http://wiki.apache.org/db-derby/SqlPsmSupport

------------------------------------------------------------------------------
  }
  }}}
  
+ Possible storage of the generated class in SYSSTATEMENTS. This table already supports
+ the storage of generated classes for stored prepared statements.
+ 
+ || Column || type || nullable || use for PSM ||
+ || STMTID || CHAR(36) || false || unique identifier for the statement (?) ||
+ || STMTNAME || VARCHAR(128) ||false || name of the routine (?)||
+ || SCHEMAID || CHAR(36) || false || the schema in which the routine resides (?) ||
+ || TYPE || CHAR(1) || false || 'P' procedure, 'F' function  ||
+ || VALID || BOOLEAN 	|| false || TRUE if valid, FALSE if invalid  (?) ||
+ || TEXT || LONG VARCHAR || false || text of the create routine statement ||
+ || LASTCOMPILED || TIMESTAMP || true ||	time that the routine was compiled ||
+ || COMPILATION SCHEMAID || CHAR(36) || false || id of the schema containing the statement (?) ||
+ || USINGTEXT || LONG VARCHAR || true || NULL ||
+ || CONSTANTSTATE (hidden) || Derby Prepared Statement (plan) || ?? || Bytecode of generated routine ||
+ || INITIALLY_COMPILABLE (hidden) || BOOLEAN || true || True or Null ||
+ 
+ * Issue with existing index on STMTNAME,SCHEMAID. Would conflict name space with statements (which only currently exist for JDBC metadata statements). Could upgrade index to include TYPE.
+