TEXTARRAY

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

TEXTARRAY Elements/Attributes

TYPE=TEXTARRAY

     
Element Attributes Attribute Value Element Value Definition

<MathVariable>

 

 

 

 

 

 

 

 

 

 

TYPE

TEXTARRAY

   

OPERATION

APPEND

A variable of type Activity whose value is appended to array SOURCEARRAY.

Results in new array equal to array indicated by SOURCEARRAY attribute with an additional Activity object appended.

Note:  If the SOURCEARRAY attribute is specified, the name must be the same as the name of the specified VARIABLENAME.

The append operation will insert the Activity math object at the end of the array.

ARRAYFUNCTION

Any valid function call. Valid functions are defined in the FUNCTION business rule.

Executes a function in a manner similar to a FUNCTIONCALL variable except that it operates on each element of any arrays in the expression.

COPY   Takes a SOURCEARRAY attribute and creates a separate but identical array.
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 field value defaulting to the value of its DEFAULT attribute.

When using the CREATE operation, the value of the MathVariable cannot be blank and must be an integer (or a MathVariable containing an integer).

This value allows the system to predetermine the size of the array to build and reserve memory for it. Note: This value should be instantiated as zero (0) if the size of the array is not yet known.

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 an array by duplicating each element of the original array a given number of times. As a comma delimited list of three multiplier values:

The first multiplier indicates the number of times that the first element of the array is repeated.

The middle multiplier indicates the number of times that all elements other than the first and last elements are repeated.

The last multiplier indicates the number of times that the last element of the array is repeated.

FILLBYDEPOSIT

   

FILLBYFUND

   
FILLBYLIST Comma separated list of integer constants and/or variable names. Fills the array with the values entered.

FILLBYSQL

A valid SQL statement that returns one or more integer values.

Creates an array of the resulting data returned by a SQL statement. The SQL statement must return one column with any number of rows.

INSERT

A variable of type Activity whose value is placed in the array at a specific location/index.

The object is inserted into the array using insert operation. If the specified index does not exist (e.g. the array is too short), it will be inserted at the end of the array.

REMOVE   Results in an array identical to SOURCEARRAY with the element at INDEX removed.

REPLACE

A variable or integer literal to replace one or more of the elements of the current array.

Replaces a value at the specified array position with the element’s value. The INDEX attribute will either have one 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 MathVariable. If INDEX contains two values, the elements from the first index to and including the second index are replaced by the value provided by the MathVariable.

Note:  If the SOURCEARRAY attribute is specified, the name must be the same as the name of the specified VARIABLENAME.

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 MathVariable, which is also an array.  When multiple arrays are used, they must have the same length.

XML Schema

When OPERATION="APPEND"

<MathVariable VARIABLENAME="[String]" TYPE="TEXTARRAY" OPERATION="APPEND" SOURCEARRAY="[String]" DATATYPE="TEXT">[String]</MathVariable>

When OPERATION="ARRAYFUNCTION"

<MathVariable VARIABLENAME="[String]" TYPE="TEXTARRAY" OPERATION="ARRAYFUNCTION" DATATYPE="TEXT">[String]</MathVariable>

When OPERATION="COPY"

<MathVariable VARIABLENAME="[String]" TYPE="TEXTARRAY" OPERATION="COPY" SOURCEARRAY="[String]" DATATYPE="TEXT">[String]</MathVariable>

When OPERATION="EXPAND"

<MathVariable VARIABLENAME="[String]" TYPE="TEXTARRAY" OPERATION="EXPAND" SOURCEARRAY="[String]" DATATYPE="TEXT">[String]</MathVariable>
<MathVariable VARIABLENAME="[String]" TYPE="TEXTARRAY" OPERATION="EXPAND" SOURCEARRAY="[String]" DATATYPE="TEXT">[String],[String],[String]</MathVariable>
<MathVariable VARIABLENAME="[String]" TYPE="TEXTARRAY" OPERATION="EXPAND" MULTIPLIER="[String]" DATATYPE="TEXT">[String]</MathVariable>
<MathVariable VARIABLENAME="[String]" TYPE="TEXTARRAY" OPERATION="EXPAND" MULTIPLIER="[String],[String],[String]" DATATYPE="TEXT">[String]</MathVariable>

When OPERATION="FILLBYDEPOSIT"

<MathVariable VARIABLENAME="[String]" TYPE="TEXTARRAY" OPERATION="FILLBYDEPOSIT" DATATYPE="TEXT">[String]</MathVariable>

When OPERATION="FILLBYFUND"

<MathVariable VARIABLENAME="[String]" TYPE="TEXTARRAY" OPERATION="FILLBYFUND" DATATYPE="TEXT">[String]</MathVariable>

When OPERATION="FILLBYLIST"

<MathVariable VARIABLENAME="[String]" TYPE="TEXTARRAY" OPERATION="FILLBYLIST" DATATYPE="TEXT">[String]</MathVariable>

When OPERATION="FILLBYSQL"

<MathVariable VARIABLENAME="[String]" TYPE="TEXTARRAY" OPERATION="FILLBYSQL" DATATYPE="TEXT">[SqlStatement]</MathVariable>

When OPERATION="INSERT"

<MathVariable VARIABLENAME="[String]" TYPE="TEXTARRAY" OPERATION="INSERT" INDEX="[String]" SOURCEARRAY="[String]" DATATYPE="TEXT">[String]</MathVariable>

When OPERATION="REMOVE"

<MathVariable VARIABLENAME="[String]" TYPE="TEXTARRAY" OPERATION="REMOVE" INDEX="[String]" SOURCEARRAY="[String]" DATATYPE="TEXT"></MathVariable

When OPERATION="REPLACE"

<MathVariable VARIABLENAME="[String]" TYPE="TEXTARRAY" OPERATION="REPLACE" INDEX="[String]" SOURCEARRAY="[String]" DATATYPE="TEXT">[String]</MathVariable>

When OPERATION="TRANSFORM"

<MathVariable VARIABLENAME="[String]" TYPE="TEXTARRAY" OPERATION="TRANSFORM" DATATYPE="TEXT">[String]</MathVariable>

 

 

 

 

 

Oracle Insurance Logo Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us