B. SQLSTATE Values and Generic Error Codes : Generic Error Codes : Generic Error Data Exception Subcodes
 
Share this page                  
Generic Error Data Exception Subcodes
The following table lists subcodes returned with generic error
-402 (generic errors -40200 through -40299):
Subcode
Description
00
No subcode
01
Character data truncated from right
02
Null value, no indicator variable specified
03
Exact numeric data, loss of significance (decimal overflow)
04
Error in assignment
05
Fetch orientation has value of zero
06
Invalid date or time format
07
Date/time field overflow
08
Reserved
09
Invalid indicator variable value
10
Invalid cursor name
15
Invalid data type
20
Fixed-point overflow
21
Exponent overflow
22
Fixed-point divide
23
Floating point divide
24
Decimal divide
25
Fixed-point underflow
26
Floating point underflow
27
Decimal underflow
28
Other unspecified math exception
99
Maximum legal subcode