STOREDPROCEDURE-COLLECTION

Description

Provides the ability to call a stored procedure that returns key-value pairs. A stored procedure may return multiple rows of two columns. This is accepted by math as a collection. A collection in math is a series of key-value pairs where each key value is unique. The first column from the data return is the key and the second column is the value. All data must be compatible with the math variable data type of text though the data type for the variable is MAP. The variable type is STOREDPROCEDURE-COLLECTION.

STOREDPROCEDURE-COLLECTION Element/Attribute Table

TYPE=STOREDPROCEDURE-COLLECTION

Element	Attributes	Attribute Value	Element Value	Definition
<MathVariable>	TYPE	STOREDPROCEDURE-COLLECTION
	VARIABLENAME	A name that succinctly identifies the contents of the variable.
	PROCEDURENAME	Name of the stored procedure exactly as it is defined.		Provides the name of the stored procedure.
	DATATYPE	MAP		The data type of the variable.
<Parameters>				Opening element that allows multiple parameters to be defined.
<Parameter>			Variable name defined in a prior math statement, literal value or expression that results in an appropriate data type.	Defines the values to be passed as input to the stored procedure.
	NAME	A literal value.		Defines the name of the parameter exactly as defined in the stored procedure.
	DATATYPE	A literal value. Values are limited to: DATE TEXT INTEGER DECIMAL

XML Sample

<MathVariable VARIABLENAME="RateMap" TYPE="STOREDPROCEDURE-COLLECTION" DATATYPE="MAP" PROCEDURENAME="TestRateMapProc">

<Parameters>

<Parameter NAME="AGE" DATATYPE="INTEGER">VarAge</Parameter>

<Parameter NAME="SEX" DATATYPE="TEXT">01</Parameter>

</Parameters>

</MathVariable>