Previous Topic: IDAETERR83 - Plan module not found and SET RUN SQL STATICNext Topic: IDAETERR85 - Compile date NE pgm plan date and SET RUN SQL STATIC

Application Execution (AE) Messages › › IDAETERR84 - Program not in plan and SET RUN SQL STATIC

IDAETERR84 - Program not in plan and SET RUN SQL STATIC

Reason:

Access to DB2 through static SQL is not possible for the current program, because this program was not specified on the plan resources panel either explicitly, or as part of some application. Dynamic SQL is prohibited because the command SET RUN SQL STATIC is in effect.

Action:

To execute dynamic SQL, issue the command SET RUN SQL MIXED. To execute static SQL, modify the plan resources as necessary, and regenerate the plan. Check the plan generation report to ensure that the program was included.