OPTIMIZE FOR clause not supported in a compound statement

  Explanation:  A select specification specified an OPTIMIZE FOR
  clause.  This clause is not supported for statements within a
  compound statement.

  User Action:  The optimization for a multistatement procedure
  should always be TOTAL_TIME.