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

Oracle® Insurance Rules Palette Release 9.3.1.0 E21044_01

# STRINGARRAY

## Description

A set of methods determined by the OPERATION type that performs math operations on arrays of text values.

## STRINGARRAY Element/Attribute Table

TYPE=DATEARRAY

Element | Attributes | Attribute Value | Element Value | Definition
--- | --- | --- | --- | ---
<MathVariable> | TYPE | STRINGARRAY |  |
| 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.
|  | COPY |  | Takes a SOURCEARRAY attribute and creates a separate but identical array.
|  | REPLACE | A variable or string 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.
|  | REMOVE | N/A | Results in an array identical to SOURCEARRAY with the element at INDEX removed.
|  | APPEND | A variable or string literal whose value is appended to SOURCEARRAY. | Results in new array equal to array indicated by SOURCEARRAY attribute with element value appended.
|  | INSERT | A variable or string literal whose value is to be inserted into a SELECTARRAY at INDEX. | Results in the new array equal to the array indicated by SOURCEARRAY attribute with an element value inserted at the index indicated by INDEX attribute.
|  | FILLBY-LIST | Comma separated list of date constants and/or variable names. | Fills the array with the values entered.
|  | FILLBY-SQL | SQL select statement that selects string values from a single column from the database. | Fills the array with the values returned from SQL.
|  | FILLBY-DEPOSIT | No value needed for element. | Fill an array with DepositGUIDs for funds on a policy. Usually a datatype is considered string.
|  | FILLBY-FUND | No value needed for element. | Fills an array with FundGUIDs on a policy. Usually a datatype is considered string.
|  | 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 where one or more of the variables used in the expression are arrays.
|  | ARRAYFUNCTION | Any valid function call. | Executes a function.
|  | EXPAND | Use the MULTIPLIER attribute to indicate the number of times each element of the original array should be duplicated. The first and last elements may have a different number of duplicates than the other elements, so this attribute's value can be a comma delimited list of, at most, three values. If only one value is supplied, the others are defaulted to that value. | Creates a new array by duplicating each element of the original array a given number of times.
|  | SETMIN | A variable or string literal. | Results in new array in which each element is the smaller of the corresponding element from SOURCEARRAY and the string element value.
|  | SETMAX | A variable or string literal. | Results in new array where each element is the larger of the corresponding element from SOURCEARRAY and the string element value.
|  | STRIDE | A variable or string literal. | Results in new array containing every nth element of the SOURCEARRAY where n is the element value.
|  | FILLBY-STOREDPROCEDURE |  | Fills the math variable with a string 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 elements are applicable for FILLBY-STOREDPROCEDURE only.
<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 |  | Defines a data type expected by the stored procedure.

## XML Example

    MathVariable VARIABLENAME="TypeCodeArray" TYPE="STRINGARRAY" OPERATION="CREATE" DATATYPE="TEXT">SegmentCount</MathVariable>

    <MathVariable VARIABLENAME="Guids" TYPE="STRINGARRAY" OPERATION="FILLBY-STOREDPROCEDURE" DATATYPE="TEXT" 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