SQL Codes › SQL Return Codes -1 through -999 › -310 - COMBINATION OF CHECKPLAN=checkplan_value, CHECKWHO=checkwho_value, AND CHECKWHEN=checkwhen_value IS INVALID

-310 - COMBINATION OF CHECKPLAN=checkplan_value, CHECKWHO=checkwho_value, AND CHECKWHEN=checkwhen_value IS INVALID

Explanation

The plan options specify an invalid combination of values for CHECKPLAN, CHECKWHEN, and CHECKWHO. The valid combinations are listed below.

• CHECKPLAN=N
• CHECKPLAN=N,CHECKWHEN=EXECUTE,CHECKWHO=ACCESSOR
• CHECKPLAN=Y,CHECKWHEN=EXECUTE,CHECKWHO=ACCESSOR
• CHECKPLAN=Y,CHECKWHEN=BIND,CHECKWHO=BINDER

The SQLSTATE that equates to this SQL return code is 53S29.

User Response

Modify the plan options to contain a valid combination of values. See the preprocessor options in the CA Datacom/DB SQL User Guide or the CA Datacom Security Reference Guide for more information.