The embedded SQL statement is not within the program block

  Explanation:  The embedded SQL statement is either before the
  program statement or after the last end statement.

  User Action:  Move the embedded SQL statement between the
  program statement and the last end statement.