You are here: Transaction Rules > Transaction Elements > Math Elements > COLLECTION and KEY

Oracle® Insurance Rules Palette Release 9.3.1.0 E21044_01

# COLLECTION and KEY

## Description

This math element is used to execute a SQL statement that will return two result columns as a key-value pair. The first column is considered the key with the second column a value. A subsequent statement of type COLLECTIONVALUE is used to access the key to retrieve its associated value

## COLLECTION and KEY Element/Attribute Table

TYPE=COLLECTION KEY=GUID
Element | Attribute | Attribute Value | Element Value
<MathVariable> | TYPE | COLLECTION | SQL statement. The data type is always MAP.

## XML Example

<MathVariable VARIABLENAME="FundGUIDs" TYPE="COLLECTION" DATATYPE="MAP">SELECT AsFundField.TextValue, AsFund.FundGUID FROM AsFund WHERE AsFundField.FieldName = 'FundID' AND AsFundField.TextValue IN ('1600','1601','1602')</MathVariable>

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

Open table of contents