Rules for Using WHENEVER - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

Product
Preprocessor2 for Embedded SQL
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

Rules for Using WHENEVER

  • 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.