SQL : Error handling : WHENEVER stmt

The WHENEVER statment specifies the action to be taken when a specified exception condition occurs
This stmt can only be empedded in an application program. It is not an exeuctable stmt. It must not be specified in Java or REXX.

Syntax:
WHENEVER <>

Default :
WHENEVER <> CONTINUE.

PLI: ENVIRONMENT(CTLASA)

CTLASA option specifies American National Standard Vertical carriage positioning characters or American National standard Pocket selection characters (Level 1). The CTL360 option specifies IBm machine-code control characters.
The American National Standard control characters:
(blank) Space 1 line before printing
0 Space 2 lines before printing
- Space 3 lines before printing
+ Suppress space before printing
1 Skip to channel 1
2 Skip to channel 2
.
.
.
9 Skip to channel 9
A Skip to channel 10
B Skip to channel 11
C skip to channel 12
V select stacker 1
W select stacker 2

SQLCODE = -401 SQLSTATE= 42818

THE OPERANDS OF AN ARITHMETIC OR COMPARISON OPERATION ARE NOT COMPARABLE

SQLCODE = -181 SQLSTATE=22007

THE STRING REPRESENTATION OF A DATETIME VALUE IS NOT A VALID DATETIME VALUE

Bad data in Date/Time/Timestamp
Value for DATE, TIME, TIMESTAMP is invalid

Ex: 0000-00-00

SQLCODE = -180 SQLSTATE= 22007

Bad data in Date/time/timestamp
String representation of DATE, TIME, TIMESTAMP is invalid.

SQLCODE = -117

The number of values you are trying to INSERT does not match the number of
columns