Previous Topic: IDAETERR80 - Plan module not found and Dynamic SQL=NO in planNext Topic: IDAETERR82 - Compile date NE pgm plan date and Dynamic SQL=NO

Application Execution (AE) Messages › › IDAETERR81 - Program not in plan and Dynamic SQL=NO in plan

IDAETERR81 - Program not in plan and Dynamic SQL=NO in plan

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 plan parameters specify Dynamic SQL? = NO.

Action:

Modify the plan resources as necessary and reGENERATE the plan. Check the Plan Generation Report to insure that the program was included.