8.1 SQLSTATE

SQLSTATE is one of the codes returned by HiRDB after execution of SQL statements.

This code consists of five digits, where the first two digits indicate the class and the remaining three digits indicate the subclass.

If you specify YES in the PDSTANDARDSQLSTATE client environment variable or Y in the pd_standard_sqlstate system common definition, detailed information is set in SQLSTATE.

Table 8-1 Classes of SQLSTATE returned by HiRDB and their explanations lists and describes classes of SQLSTATE returned by HiRDB and tells the user where in this chapter to find detailed information for each class. Tables 8-2 SQLSTATE class 00 through Tables 8-40 SQLSTATE class R2 list and explains the meanings of SQLSTATE returned by HiRDB for each class.

Table 8-41 Classes of SQLSTATE returned by HiRDB and their explanations lists and describes classes of SQLSTATE, and tells the user which of the following tables provide detailed information for each class. Tables 8-42 SQLSTATE class 00 through Tables 8-47 SQLSTATE class R2 list and explains the meanings of SQLSTATE returned by HiRDB for each class.

When SQLSTATE is returned, the user must reference the message or the information provided in the Explanation column of the applicable table, and take an appropriate action.

Organization of this section
8.1.1 When the PDSTANDARDSQLSTATE client environment variable is set to YES or the pd_standard_sqlstate system common definition is set to Y
8.1.2 When the PDSTANDARDSQLSTATE client environment variable is set to NO or the pd_standard_sqlstate system common definition is set to N