'$RCSfile: eml-storedProcedure.xsd,v $' Copyright: 1997-2002 Regents of the University of California, University of New Mexico, and Arizona State University Sponsors: National Center for Ecological Analysis and Synthesis and Partnership for Interdisciplinary Studies of Coastal Oceans, University of California Santa Barbara Long-Term Ecological Research Network Office, University of New Mexico Center for Environmental Studies, Arizona State University Other funding: National Science Foundation (see README for details) The David and Lucile Packard Foundation For Details: http://knb.ecoinformatics.org/ '$Author: obrien $' '$Date: 2009-02-25 23:51:54 $' '$Revision: 1.46 $' This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA eml-storedProcedure

The storedProcedure module is meant to capture information on procedures that produce data output in the form of a data table. In an RDBMS one can code complex queries and transactions into stored procedures and then invoke them directly from front-end applications. It allows the optional description of any parameters that are expected to be passed to the procedure when it is called.

Use the storedProcedure module to document datasets that use storedProcedures to retrieve archived data. yes Stored Procedure> The storedProcedure element documents stored procedures. The storedProcedure element is meant to capture information on procedures that produce data output in the form of a data table. In an RDBMS one can code complex queries and transactions into stored procedures and then invoke them directly from front-end applications. This element allows the optional description of any parameters that are expected to be passed to the procedure when it is called. A common use of a stored procedure is to rotate a data table from attributes in columns to attributes in rows for statistical analysis. Stored Procedure complex type> Structure for documenting a stored procedure The StoredProcedureType complex type defines the structure for documenting a stored procedure. Attribute List The list of attributes associated with this entity. The list of attributes associated with this entity. For more information see the eml-attribute module. Constraint Description of any relational constraints on ' this entity. For more information see the eml-constraint module. Parameter A parameter that is required as input to the stored procedure. The parameter elements defines the fields that may be required to invoke a stored procedure. Parameter complex type The structure for defining a parameter that is required as input to the stored procedure. The parameter complex type defines the structure for documenting the parameters that may be required to invoke a stored procedure. Parameter Name The name of the parameter. The value of the name field is the name of the parameter. SiteID Domain Description A description of domain of valid values for the parameter. The domainDescription field is used to describe the valid entries for the parameter being described. A stored procedure will work only when the parameter's value corresponds to an actual value in a database. The database has SiteId values that range from cap1 to cap10, however the allowable SiteId values for this stored procedure are cap1,cap2,cap4 or cap7. Required Whether or not the parameter is required. The required field is used to document whether the parameter being described is or is not required when invoking the stored procedure. true Repeats Whether or not the parameter repeats. The repeats field is used to document whether or not the parameter being described can be repeated when invoking the stored procedure. true