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

Example 4 SQL Statement to Delete a Row
For OCI:
SQLAction StopSession {
{
input
RAD(Class) DBP(sessid, 254, CHAR)
output
DBR(DBretCode) FUNC(ACKonZero)
SQLStatement db_oci {
DELETE FROM RAD_SESS_TABLE
WHERE session_id=:sessid
}
}
}
For ODBC:
SQLAction StopSession {
{
input
RAD(Class) DBP(1, 254, CHAR)
output
DBR(DBretCode) FUNC(ACKonZero)
SQLStatement db_odbc {
DELETE FROM RAD_SESS_TABLE
WHERE session_id=sessid
}
}
}
The following example is the equivalent replacement of the above examples for the new result
mapping syntax using RET:
For OCI:
SQLAction StopSession {
{
input
RAD(Class) DBP(sessid, 254, CHAR)
output
DBR(-1:*) RET(ERROR)
DBR(0:0) RET(ACK)
DBR(*:*) RET(NAK)
SQLStatement db_oci {
DELETE FROM RAD_SESS_TABLE
WHERE session_id=:sessid
}
}
}
For ODBC:
SQLAction StopSession {
{
input
RAD(Class) DBP(1, 254, CHAR)
output
DBR(-1:*) RET(ERROR)
DBR(0:0) RET(ACK)
DBR(*:*) RET(NAK)
SQLStatement db_odbc {
Implementing SQL Access 265