15.10 - Rules for Using WHENEVER - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

prodname
Preprocessor2 for Embedded SQL
vrm_release
15.10
category
Programming Reference
featnum
B035-2446-035K
  • The WHENEVER statement must precede the SQL statement or statements for which the condition is to apply.
  • When it is used, the host label object must be a section name or an unqualified paragraph name.
  • When a PERFORM or CALL action is used, the PERFORM code object and the CALL function call must be such that PERFORM code or CALL function call is valid at every SQL statement to which that exception declaration applies.