CHAPTER 10 Database Error Messages
669
Error messages indexed by SQLSTATE
Adaptive Server Anywhere supports the SQLSTATE error code defined by
SQL/92. Each SQLSTATE value is a 5- character string containing a 2-
character class followed by a 3-character subclass. Each character can be one
of the uppercase letters A through Z or the digits 0 through 9. A class that
begins with A through H or 0 through 4 has been defined by the ANSI
standard; other classes are implementation defined. Similarly, subclasses of
standard classes that start with the same characters (A-H, 0-4) are standard.
The subclass 000 always means that no subclass code is defined. The most
common SQLSTATE value is 00000, which indicates successful completion.
SQLSTATE Error message
00000 "(no message)" on page 711
01000 "Warning" on page 925
01001 "Cursor operation conflict" on page 770
01003 "Null value eliminated in aggregate function" on page 839
01004 "Value truncated" on page 924
01W02 "Using temporary table" on page 922
01W03 "Invalid data conversion" on page 806
01W04 "Row has been updated since last time read" on page 860
01W05 "Procedure has completed" on page 849
01W06 "Value for column ’%1’ in table ’%2’ has changed" on page 923
01W07 "Language extension detected in syntax" on page 828
01W08 "Statement cannot be executed" on page 872
01W09 "More information required" on page 831
01W10 "Transaction log backup page only partially full" on page 903
01W11 "Database option ’%1’ for user ’%2’ has an invalid setting" on
page 774
01W12 "Character set translation to ’%1’ cannot be performed; ’%2’ is
used instead" on page 752
01W13 "Unsupported character set ’%1’" on page 912
01W14 "Unsupported language; language used is ’%1’ instead" on
page 913
01W15 "Unsupported character set ’%1’ and unsupported language;
language used is ’%2’ instead" on page 912
01W16 "Illegal user selectivity estimate specified" on page 798
To Next Page
Loading...