DB2 SQL-Error: -549
SQLState: 42509
Short Description: THE STATEMENT IS NOT ALLOWED FOR BECAUSE THE BIND OPTION DYNAMICRULESRUN IS NOT IN EFFECT FOR
A program attempted to issue the indicated SQL statement that is one of several SQL statements that cannot be issued from a plan or package for which the option DYNAMICRULES(RUN) is not in effect. Those SQL statements are: v Dynamic GRANT statement v Dynamic REVOKE statement v Dynamic ALTER statement v Dynamic CREATE statement v Dynamic DROP statement The indicated SQL statement is bound to one of the following: v The named plan or package that was not bound with the option DYNAMICRULES(RUN) v The named package that was not bound with the DYNAMICRULES option, but is appended to a plan that was not bound with DYNAMICRULES(RUN)statement The SQL statement in error object_type1 PACKAGE or DBRM object_name If object_type1 is PACKAGE, object_name is the name of the package in the format Â’location-id.collection-id.package-idÂ’. If object_type1 is DBRM, object_name is the name of the DBRM in the format Â’plan-name DBRM-nameÂ’. object_type2 PLAN or PACKAGE If object_type1 is PACKAGE, object_type2 can be either PACKAGE or PLAN (whichever is bound with a DYNAMICRULES value other than RUN). If object_type1 is DBRM, object_type2 is PLAN.System action: The SQL statement cannot be executed. Programmer response: Do one of the following to correct the error: v If the SQL statement is embedded, remove it, precompile and compile the application program again, and reissue the BIND command with the desired DYNAMICRULES option. v If appropriate, use the SQL statement with a package or plan that is bound with DYNAMICRULES(RUN). v Issue the REBIND command with the DYNAMICRULES(RUN) option for the plan or package to which the SQL statement is bound Refer to the BIND PACKAGE(DSN), BIND PLAN(DSN), REBIND PACKAGE(DSN), or REBIND PLAN(DSN) statement in DB2 Command Reference for the description of the DYNAMICRULES option and the expected results. Determine if either the SQL statement should be removed from the program or the plan or package should be rebound with the DYNAMICRULES(RUN) option.