'$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
moduleName: eml-storedProceduremoduleDescription: The eml-storedProcedure module - Data tables resulting from procedures stored in a databaserecommendedUsage: Use the storedProcedure module to document datasets that use storedProcedures to retrieve archived data.standAlone: yes
tooltip: Attribute Listsummary: The list of attributes associated with this entity.description: The list of attributes associated with this entity. For more information see the eml-attribute module.
tooltip: Constraintsummary: description: Description of any relational constraints on ' this entity. For more information see the eml-constraint module.
tooltip: Parametersummary: A parameter that is required as input to the stored procedure.description: The parameter elements defines the fields that may be required to invoke a stored procedure.
tooltip: Domain Descriptionsummary: A description of domain of valid values for the parameter.description: 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.example: 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.
tooltip: Requiredsummary: Whether or not the parameter is required.description: The required field is used to document whether the parameter being described is or is not required when invoking the stored procedure.example: true
tooltip: Repeatssummary: Whether or not the parameter repeats.description: The repeats field is used to document whether or not the parameter being described can be repeated when invoking the stored procedure.example: true
tooltip: Stored Procedure>summary: The storedProcedure element documents stored procedures.description: 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.
tooltip: Stored Procedure complex type>summary: Structure for documenting a stored proceduredescription: The StoredProcedureType complex type defines the structure for documenting a stored procedure.
tooltip: Parameter complex typesummary: The structure for defining a parameter that is required as input to the stored procedure.description: The parameter complex type defines the structure for documenting the parameters that may be required to invoke a stored procedure.