Neoview Messages Manual (Volume 2) (R2.5)

3 SQLSTATE Values Returned by the Neoview Database
The HP Neoview database software returns SQLSTATE values that are defined in the ISO/ANSI
SQL standard and implementation-defined SQLSTATE values. See Subclause 22, “Status Codes”
in the ISO/ANSI SQL92 Standard “Database Language SQL.”
SQLSTATE and SQLCODE Considerations
• Using SQLSTATE causes performance overhead because of the representation of SQLSTATE
as five characters. The overhead is most noticeable with short SQL statements and in error
situations.
• Mapping SQLSTATE values to SQLCODE values can result in ambiguous SQLCODE values:
— SQLCODE values will often not map to a unique SQLSTATE value. For example, see
the many SQLCODE values mapped to SQLSTATE 42000 in Table 3-7 (page 136).
— To deal with the problem of ambiguous SQLCODE values, HP recommends retrieving
the error message text or the SQLCODE value in addition to the SQLSTATE.
• SQLSTATE values for some Neoview database error and warning messages might be subject
to change:
— In the future, Neoview database software might return different SQLSTATE values for
error conditions than it does now.
— In the future, the Neoview database error handling might use a different error path,
and therefore return a slightly different SQLCODE and implementation-defined
SQLSTATE value for an error.
SQLSTATE Values
Returned SQLSTATE values are listed the tables in this section. These lists are ordered by
SQLSTATE. SQLCODE values that are provided for both warning messages (positive SQLCODE
numbers) and error messages (negative SQLCODE numbers). The tables are:
• SQLSTATE Values Beginning 00000 in Table 3-1 (page 100)
• SQLSTATE Values Beginning 01700 in Table 3-2 (page 107)
• SQLSTATE Values Beginning 01800 inTable 3-3 (page 113)
• SQLSTATE Values Beginning 01I01 in Table 3-4 (page 118)
• SQLSTATE Values Beginning 01M01n in Table 3-5 (page 124)
• SQLSTATE Values Beginning 07001 in Table 3-6 (page 131)
• SQLSTATE Values Beginning 42000 in Table 3-7 (page 136)
• SQLSTATE Values Beginning 44000 in Table 3-8 (page 145)
• SQLSTATE Values Beginning X0700 in Table 3-9 (page 154)
• SQLSTATE Values Beginning X0D01 in Table 3-10 (page 159)
SQLSTATE and SQLCODE Considerations 99