You are here: Configuration > Transactions > Configuration Panes > SQL

Oracle® Insurance Rules Palette 9.4.1.0 E23637_01

# SQL

The SQL math variable is used to retrieve data results using a SELECT statement. SQL is used to retrieve a value from the database using a query statement. The SQL statement should be constructed to return one value.

SQL Math Variable in Palette

Note: For a comprehensive explanation of the characteristics of this math variable, refer to the XML Configuration Guide in the Help menu.

## Define the SQLMath Variable

Drag and drop the SQL Math variable from the Palette window onto the Math Pane. Enter the following information for the math variable.

- Type a name in the Name field. This is required.

- The applicable Data Types are: Boolean, Date, Decimal, Integer and Text. This is required.

- Make sure variable type is defined as SQL. This is required.

- Select Yes or No from Log field. Default is No. This is an optional field.

- The Default is left blank and is an optional field. Required for Date and Integer data types so the system does not return a null value. For example, an integer default could be set to -999999999. Numeric and Date data types must consider a default whereas, text data type is more flexible and will not require a default value.

- Enter the SQLQuery / SQL query statement. This is required.

Check-in the transaction to save the information to the database.

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