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

/*SQL Action Definition*/
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 */
}
Database Connection Definition
Define the database connection parameters in the data structure identified with the keyword DBID.
The syntax of DBID is as follows:
DBID instance {
DBClient db_client_library_interface
[DBUser db_user]
[DBPassword db_user_password]
[ReconnectWaitTime reconnect_wait_time]
[ReconnectErrorCodes reconnect_err_code]
[OracleSID Oracle_db_instance]
[ODBCDatastore ODBC_db_instance]
}
Where:
instance Identifies a unique instance of the AAA Server as a database client. Note that the
database connection parameters for a particular instance must be defined before
the SQL actions for that particular database instance in the sqlaccess.config
file.
Table 71 (page 256) lists the database access parameters and their usage:
Table 71 Database Access Parameters
DescriptionDatabase Access Variable
Mandatory. Identifies the database client library.db_client_library_interface
Values: OracleOCI or ODBC
Optional for database clients that maintain user and password information
in their configuration file.
User identity for database connection.
db_user
Optional for database clients that maintain user and password information
in their configuration file. Password for database connection. Some client
db_user_password
256 SQL Access