HP-UX AAA Server A.08.02 Administrator's Guide

SQLAction action_ID
{
[TimedEvent timed_event]
[QueryType multi_row]
/* repeat as needed */
{
[input
[source target [conversion_function]]
.
.
[source target [conversion_function]]]
[output
[source target [conversion_function]]
.
.
[source target [conversion_function]]]
[SQLStatement instance {sql_statement}]
}
/* end repeat *
Where:
action_ID Required. Specifies a unique instance of an SQL action. Identifies
the SQL action to be executed as configured in the FSM or in the
authfile file through the Local Realm screen in the Server
Manager. Follow a naming convention for action_ID that allows
for easy identification of the actions they perform to ensure the
integrity of the processing logic.
timed_event Optional. Used for actions not triggered by user requests. Specifies
the time interval in seconds for the AAA Server to execute this action.
See “Advanced SQL Mapping Configuration” (page 269) for more
information.
QueryType multi_row Optional. Enables multi-row support for SQL Access. Supports
multiple rows returned by an SQL query. For more information, see
“Multi-Row Support For SQL Access” (page 281).
The following sections provide details on the input and output mapping syntax and the SQL
statement.
Mapping Syntax
Each input or output mapping entry consists of a source and target definition, and an optional
conversion function.
Table 72 (page 259) and Table 73 (page 259) show the source and target data types that can be
mapped depending on input or output mapping:
• RAD: identifies a RADIUS attribute in a mapping,
• DBP: identifies SQL placeholder mapping,
• DBC: identifies the database column mapping,
• DBR: handles return values from the SQL statements. See “SQL Result Mapping” (page 266)
for more information on the use of DBR mapping.
258 SQL Access