BindRules

The BindRules setting applies only to applications that use Dynamic SQL on a data source on DB2 for z/OS. Set this option to RUN or BIND as desired.

On DB2 for z/OS, the permissions required to run applications that use Dynamic SQL depend on the value of the Bind Rules option. If this option is set to RUN, the System Administrator needs to grant the user explicit permissions to read and write the columns and tables accessed by the application. If it is set to BIND, the StarSQL user executes with the permissions of the owner of the dynamic SQL package.

If the option is set to BIND, the following SQL statements cannot be executed, regardless of the actual permissions of the package owner:

• SET CURRENT SQLID

• GRANT

• REVOKE

• ALTER

• CREATE

• DROP

• Any SQL statement that cannot be prepared as dynamic SQL