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

Functions” (page 227) for more information on pre-defined mapping functions to set
event codes. For more information on event code handling for user retrieval action,
see “Result Handling for Retrieval Requests” (page 231) in this section.
If your mapping function returns an event other than ACK, control is returned to the
FSM immediately with the event code set in the mapping function.
The syntax for SQL result mapping is as follows:
DBR (result) FUNC (mappingfunction)
Where result can take one of the following values:
DBMatchRow
Returns the number of matched rows. This is useful if your database
returns a SQL result code of 0 (success) even if the number of retrieved
rows is zero. With a custom defined mapping function you can then
overwrite the event code handling and return event codes other than
ACK to the FSM.
DBRetCode
Returns the SQL result from the SQL statement as defined by the
database client library. HP provides the following pre-defined
mapping functions useful with a DBR mapping:
• ACKonAll
• ACKonZero
• NAKonZero
• RETRIEVEonZero
See “Mapping Functions” (page 210) for more information on the event
handling functions.
Result Handling for Retrieval Requests
The default FSM expects an ACK event to indicate success with the exception of retrieving
user entries, where RETRIEVE_SUCCESS is expected. Use SQL result mapping with
the RetrieveonZero mapping function in your user retrieval actions as the last
mapping entry in the output map to set the event to RETRIEVE_SUCCESS.
Implementing SQL Access 231