Bind behavior

Db2 uses the bind behavior to process dynamic SQL statements.

Begin general-use programming interface information.The bind behavior consists of the following attributes:

  • Db2 uses the authorization ID or role of the plan or package for authorization checking of dynamic SQL statements.
  • Unqualified table, view, index, and alias names in dynamic SQL statements are implicitly qualified by the default schema, which is the value of the bind option QUALIFIER. If you do not specify the QUALIFIER bind option, Db2 uses the plan or package owner as the qualifier.

    The values of the authorization ID or role and the qualifier for unqualified objects are the same as those that are used for embedded or static SQL statements.

  • The bind behavior consists of the common attribute values for bind, define, and invoke behaviors.End general-use programming interface information.