SQL Codes › SQL Return Codes -1 through -999 › -123 - PLAN ALREADY EXISTS

-123 - PLAN ALREADY EXISTS

Reason:

The CA Datacom/DB SQL Preprocessor attempted to add a plan, but the plan was found to exist already in the Data Definition Directory or in memory.

The SQLSTATE that equates to this SQL return code is 56S02.

Action:

First, try to preprocess again. If unsuccessful, use the CA Datacom Datadictionary Interactive SQL Service Facility to drop the plan and then preprocess again.