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

Table 8-41 Classes of SQLSTATE returned by HiRDB and their explanations

ClassExplanationReference
00Terminated normally.Table 8-42
01A warning was issued.Table 8-43
02There is no data.Table 8-44
40The transaction rolled back.Table 8-45
R0Terminated abnormally.Table 8-46
R2There is no data.Table 8-47

Table 8-42 SQLSTATE class 00

SQLSTATEExplanationSQLCODESQLWARN
00000Terminated normally.0None

Table 8-43 SQLSTATE class 01

SQLSTATEExplanationSQLCODESQLWARN
01000Terminated normally with a warning.0SQLWARN0='W'
0100CA dynamic result set was returned.120SQLWARN0='W'
0100DAnother result set wass returned.121SQLWARN0='W'
0100EAn attempt was made to return too many result sets.120SQLWARN0='W'
01R00Terminated normally with a warning.Positive number other than 100 or 110SQLWARN0=space-character or 'W'

Table 8-44 SQLSTATE class 02

SQLSTATEExplanationSQLCODESQLWARN
02000There is no data.100None
02001There is no other result set to be returned.100None

Table 8-45 SQLSTATE class 40

SQLSTATEExplanationSQLCODESQLWARN
40000The SQL statement terminated with an error because the transaction rolled back.
For details, refer to the error message corresponding to the SQLCODE.
-1 to -999SQLWARN0='W'
SQLWARN6='W'

Table 8-46 SQLSTATE class R0

SQLSTATEExplanationSQLCODESQLWARN
R0000Terminated abnormally.SQLCODE<0SQLWARN6=' '

Table 8-47 SQLSTATE class R2

SQLSTATEExplanationSQLCODESQLWARN
R2000During a list search, a row that existed at the time of list creation was not returned.110None