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

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 336) for more information on the
event handling functions.
• DBR (return code:error code) RET (return event)
Where values are described as follows:
return code Integer return value from ODBC or OCI APIs. For example, 0
or 100. The following table describes the different return values
for OCI and ODBC:
Table 22-10 Return Values and Description for OCI and ODBC
APIs
ODBCOCIReturn Values
SQL_SUCCESSOCI_SUCCESS0
SQL_SUCCESS_WITH_INFOOCI_SUCCESS_WITH_INFO1
SQL_NEED_DATAOCI_NEED_DATA99
SQL_NO_DATAOCI_NO_DATA100
SQL_ERROROCI_ERROR–1
SQL_INVALID_HANDLEOCI_INVALID_HANDLE–2
OCI_STILL_EXECUTING–3123
SQL_STILL_EXECUTING2
error code Native error codes from the database. For example, ORA-00000
for success. You can configure this error code as 0. Other
examples are 1, 17, and 18.
Following is an example to configure the SQL result mapping
whose return code is 0, error code is 0, and return event is ACK:
DBR (0:0) RET (ACK)
Following is an example to configure the SQL result mapping
whose return code is 0, error codes are 0,1, and 2, and return
event is ERROR:
DBR (0:0,1,2) RET (ERROR)
360 SQL Access