Neoview Messages Manual (R2.2)

22 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 22-7 (page 434).
— 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 22-1 (page 398)
• SQLSTATE Values Beginning 01700 in Table 22-2 (page 405)
• SQLSTATE Values Beginning 01800 inTable 22-3 (page 411)
• SQLSTATE Values Beginning 01I01 in Table 22-4 (page 416)
• SQLSTATE Values Beginning 01M01n in Table 22-5 (page 422)
• SQLSTATE Values Beginning 07001 in Table 22-6 (page 429)
• SQLSTATE Values Beginning 42000 in Table 22-7 (page 434)
• SQLSTATE Values Beginning 44000 in Table 22-8 (page 443)
• SQLSTATE Values Beginning X0700 in Table 22-9 (page 452)
• SQLSTATE Values Beginning X0D01 in Table 22-10 (page 457)
SQLSTATE and SQLCODE Considerations 397