Previous Topic: IDAETERR82 - Compile date NE pgm plan date and Dynamic SQL=NONext Topic: IDAETERR84 - Program not in plan and SET RUN SQL STATIC


IDAETERR83 - Plan module not found and SET RUN SQL STATIC

Reason:

Access to DB2 through static SQL is impossible because a static module for the current plan could not be loaded and dynamic SQL is prohibited because the command SET RUN SQL STATIC is in effect. (In batch, the plan name is set by the command SET RUN PLAN name. Online, the plan name is taken from the CICS RCT table entry associated with the current transaction ID.)

Action:

To execute dynamic SQL, issue the command SET RUN SQL MIXED. To execute static SQL, the static module must be generated, if it was not done or the plan was successfully refreshed. Insure that the load library containing the static module is accessible by CA Ideal.