Run behavior

Db2 processes dynamic SQL statements by using their standard attribute. These attributes are collectively called the run behavior.

The run behavior consists of the following attributes:

  • Begin general-use programming interface information.Db2 uses the authorization IDs (primary, secondary and the current SQL ID) of the application process to check for authorization of dynamic SQL statements. It also checks the role in effect if running in a trusted context.
  • Dynamic SQL statements use the values of application programming options that were specified during installation. The installation option USE FOR DYNAMICRULES has no effect.
  • The GRANT, REVOKE, CREATE, ALTER, DROP, and RENAME statements can be executed dynamically.End general-use programming interface information.