HP-UX AAA Server A.08.00.01 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 364) 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 380).
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.
348 SQL Access