This chapter lists the diagnostic messages that may be returned when executing SQL commands. Generally, there are three types of diagnostic messages:

The Data Vault Service uses SQL92-compliant SQLSTATE status codes to categorize the diagnostic messages. Each SQLSTATE code consists of a 2-character

class

, followed by a 3-character

subclass

. The class specifies general information about the error type; the subclass specifies more specific information. For example, SQLSTATE code 54503 indicates the class 54 (Privilege Errors) and the subclass 503 (“Cannot grant privileges - non-existent object”). Each of the five characters in an SQLSTATE value is a digit (0...9) or an uppercase letter (A...Z). Class codes that begin with a digit in the range 0...4, or a letter in the range A...H, are reserved for SQL92 predefined conditions. All other class codes are reserved for implementation-defined conditions.

Most of the diagnostic messages in this document are accompanied by a description of the error and warning, and some recommended course of action.