You are here: Transaction Rules > Transaction Elements > Math Elements > DATEARRAY

Oracle® Insurance Rules Palette Release 9.3.1.0 E21044_01

# DATEARRAY

## Description

A set of methods determined by the OPERATION type, which performs math operations on arrays of date values. Data type must be date.

## DATEARRAY Element/Attribute Table

TYPE=DATEARRAY

Element | Attributes | Attribute Value | Element Value | Definition
--- | --- | --- | --- | ---
<MathVariable> | TYPE | DATEARRAY |  |
| OPERATION | CREATE | A variable whose value is the length of a newly created array. | A new array with the length equal to the element value and each value defaulting to the value of DEFAULT attribute.
|  | REPLACE | A variable or date literal to replace one or more of the elements of the current array. | The INDEX attribute will either have an index value or two index values separated by a comma. If INDEX contains only one value, the element at that index is replaced by the value provided by the math variable element. If INDEX contains two values, the elements from the first index to and including the second index are replaced. Note: If the SOURCEARRAY attribute is specified, the name must be the same as the name of the specified VARIABLENAME.
|  | APPEND | A variable or date literal whose value to be appen ded to array SOURCEARRAY. | Results in new array equal to array indicated by SOURCEARRAY attribute with element value appended. Note: If the SOURCEARRAY attribute is specified, the name must be the same as the name of the specified VARIABLENAME.
|  | FILLBY-SQL | SQL select statement that returns a single column of date values from the database. | Creates an array of the resulting data returned by a SQL statement.
|  | TRANSFORM | Any valid expression. If the array elements are to be updated by using their current value in the calculation, use the name of the array in place of that value. If the value is just the name of another array variable, then that array is copied. | Performs the indicated calculation to every element of the referenced array(s) and stores each result in the math variable which is also an array. When multiple arrays are used, they must have the same length.
|  | FILLBY-STOREDPROCEDURE |  | Fills the math variable with a date array returned from the named stored procedure. This attribute requires PROCEDURENAME and a list of parameters where applicable.
<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 Example

    <MathVariable VARIABLENAME="PremiumDateArray" TYPE="DATEARRAY" OPERATION="FILLBY-SQL" DATATYPE="DATE">SELECT AsActivity.EffectiveDate</MathVariable>

    <MathVariable VARIABLENAME="Dates" TYPE="DATEARRAY" OPERATION="FILLBY-STOREDPROCEDURE" DATATYPE="DATE" PROCEDURENAME=" TestRatesProc ">

    <Parameters>

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

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

    </Parameters>

    </MathVariable>

Copyright © 2009, 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices

Open table of contents