Start of change

-775   STATEMENT SPECIFIED IN SQL ROUTINE IS NOT ALLOWED WITHIN A COMPOUND STATEMENT.

Explanation

A statement specified in the routine body is not allowed in a compound statement. An ATOMIC compound statement cannot be specified:

  • In an SQL scalar function.
  • In an SQL procedure.
  • Within another compound statement that is defined as ATOMIC.

System action

The statement cannot be processed.

User response

Remove the statement from the SQL routine, and retry your operation.

SQLSTATE

42910

End of change