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

DBP Mapping
DBP is the placeholder mapping using the placeholder syntax in the SQL statements and parameter
bind functions as defined by the OCI and ODBC library APIs. If used as a target in input mapping,
it contains a placeholder to the local data to bind to using SQL placeholders. If used as a source
in output mapping, it contains the value to be retrieved from the placeholder after execution of a
stored procedure. For more information on stored procedure, see “Stored Procedures” (page 271).
Check the latest HP-UX AAA Server Release Notes to determine if DBP is supported with your client
library.
Table 76 (page 261) lists the DBP mapping parameters and their descriptions:
Table 76 DBP Mapping Parameters
DescriptionParameter
Mandatory.placeholder
• For OCI: Any string value. Passed to the OCIBindByName function. Binds the
mapping to a placeholder in the SQL statement as defined by the OCI syntax based
on string matching.
• For ODBC: Integer value. Identifies the order or position of the DBP parameter in
the SQL statement. Passed to the SQLBindParameter function. Binds the mapping
to a placeholder in the SQL statement as specified by the ODBC syntax. Input
mappings and output mappings use separate ordering, each starting with 1.
Mandatory. Specifies the column width as defined in the database schema. Used by
the database client library to determine the length of data to reserve for processing the
column.
db_width
Mandatory. Used by the database column library to specify the type conversion to be
performed on the data. You can use one of the following keywords:
db_type
• CHAR
• INT
• RAW
Example 3 shows a single input and output mapping for OCI and ODBC.
Implementing SQL Access 261