-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