Using a Host Indicator to flag
Null values or data errors
lThe format is -> :host-identifier INDICATOR :host-indicator
lCan be used in SELECT
INTO, FETCH, SET variable, VALUES INTO
lThe indicator can specify
the following:
lNull value was returned – indicator = -1
lNull value due to data mapping error – indicator = -2
lCharacters could not be converted
lNumeric conversion error (underflow or overflow)
lArithmetic expression error (division by 0)
lDate or timestamp conversion error (a date or
timestamp that is not within the valid range of the dates for the specified
format)
lString representation of the datetime value is not valid
lMixed data not properly formed
lA numeric value that is not valid
lArgument of SUBSTR scalar function is out of range
lOriginal length of a truncated string
lRecord the seconds portion of a time if the time
is truncated on assignment to a host variable.