---

   slapd-sql    ( 5 )

---

STATEMENT CONFIGURATION

These options specify SQL query templates for loading schema
       mapping meta-information, adding and deleting entries to
       ldap_entries, etc.  All these and subtree_cond should have the
       given default values.  For the current value it is recommended to
       look at the sources, or in the log output when slapd starts with
       "-d 5" or greater.  Note that the parameter number and order must
       not be changed.

       oc_query <SQL expression>
              The query that is used to collect the objectClass mapping
              data from table ldap_oc_mappings; see "METAINFORMATION
              USED" for details.  The default is "SELECT id, name,
              keytbl, keycol, create_proc, delete_proc, expect_return
              FROM ldap_oc_mappings".

       at_query <SQL expression>
              The query that is used to collect the attributeType
              mapping data from table ldap_attr_mappings; see
              "METAINFORMATION USED" for details.  The default is
              "SELECT name, sel_expr, from_tbls, join_where, add_proc,
              delete_proc, param_order, expect_return FROM
              ldap_attr_mappings WHERE oc_map_id=?".

       id_query <SQL expression>
              The query that is used to map a DN to an entry in table
              ldap_entries; see "METAINFORMATION USED" for details.  The
              default is "SELECT id,keyval,oc_map_id,dn FROM
              ldap_entries WHERE <DN match expr>", where <DN match expr>
              is constructed based on the knowledge about how to
              normalize DN values (e.g. "dn=?" if no means to uppercase
              strings are available; typically, "<upper_func>(dn)=?" is
              used); see upper_func, upper_needs_cast, concat_pattern
              and strcast_func in "HELPER CONFIGURATION" for details.

       insentry_stmt <SQL expression>
              The statement that is used to insert a new entry in table
              ldap_entries; see "METAINFORMATION USED" for details.  The
              default is "INSERT INTO ldap_entries (dn, oc_map_id,
              parent, keyval) VALUES (?, ?, ?, ?)".

       delentry_stmt <SQL expression>
              The statement that is used to delete an existing entry
              from table ldap_entries; see "METAINFORMATION USED" for
              details.  The default is "DELETE FROM ldap_entries WHERE
              id=?".

       delobjclasses_stmt <SQL expression>
              The statement that is used to delete an existing entry's
              ID from table ldap_objclasses; see "METAINFORMATION USED"
              for details.  The default is "DELETE FROM
              ldap_entry_objclasses WHERE entry_id=?".