-843   THE SET CONNECTION OR RELEASE STATEMENT MUST SPECIFY AN EXISTING CONNECTION

Explanation

One of the following rules was violated:
  • A SET CONNECTION statement must identify an existing SQL connection of the application process.
  • A RELEASE statement must identify an existing connection of the application process.

System action

The statement cannot be processed.

Programmer response

The correction depends on the error, as follows:
  • If the location name is not the intended name, correct it.
  • If the location name does not identify an existing SQL connection, replace the SET CONNECTION with a CONNECT statement.
  • If RELEASE CURRENT was executed in the unconnected state or the specified location name does not identify an existing SQL or DB2® private connection, delete the RELEASE statement.

Correct the error in the application, rebind, the plan and resubmit the job.

SQLSTATE

08003