Define behavior

When the package is run as or under a stored procedure or a user-defined function package, Db2 processes dynamic SQL statements by using the define behavior.

Begin general-use programming interface information. The define behavior consists of the following attribute values:

Db2 uses the authorization ID or role of the user-defined function or the stored procedure owner for authorization checking of dynamic SQL statements in the application package.
The default qualifier for unqualified objects is the user-defined function or the stored procedure owner.
Define behavior consists of the common attribute values for bind, define, and invoke behaviors.

When the package is run as a stand-alone program, Db2 processes dynamic SQL statements using bind behavior or run behavior, depending on the DYNAMICRULES value specified. End general-use programming interface information.