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

Example 18-5 SQL Statement with Result Mapping - OCI
SQLAction RetrieveUser {
{
input
RAD(User-Id,REPLY) DBP(userid, 254, CHAR)
output
DBC(user_password, 128, CHAR) RAD(Password,CHECK)
DBC(address_pool, 128, CHAR) RAD(Address-Pool,REPLY)
DBR(DBretCode) FUNC(RETRIEVEonZero)
SQLStatement db_oci {
SELECT user_password, address_pool
FROM RAD_USERS_TABLE
WHERE user_name=:userid
}
}
}
Global Definitions
Global definitions are placed anywhere in the sqlaccess.config file, but outside
the DBID and SQLAction data structures. They allow you to set up the path to custom
mapping and conversion functions.
The syntax is as follows:
[SQLMapConvLibs [“path_to_lib:path_to_lib:…:path_to_lib”]]
Where:
path_to_lib
Define the list of libraries containing mapping and conversion
functions with full path name.
Advanced SQL Mapping Configuration
This section covers the following advanced SQL Access topics:
• “Developing Custom Functions” (page 233): to extend the functionality of the AAA
Server utilizing the flexible design of the SQL Access feature;
• “Null SQL Statements” (page 233): for SQL statements without mapping or SQL
statements;
• “Time Synchronization” (page 234): to synchronize across multiple AAA Servers;
• “Finite State Table Configuration in the FSM” (page 235): to enable SQL action
execution for complex database interactions or function execution;
• “Stored Procedures” (page 236): to use stored procedures in the database.
232 SQL Access