Nonstop Database, HiRDB Version 9 Messages

[Contents][Index][Back][Next]

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

Class Explanation Reference
00 Terminated normally. Table 8-42
01 A warning was issued. Table 8-43
02 There is no data. Table 8-44
40 The transaction rolled back. Table 8-45
R0 Terminated abnormally. Table 8-46
R2 There is no data. Table 8-47

Table 8-42 SQLSTATE class 00

SQLSTATE Explanation SQLCODE SQLWARN
00000 Terminated normally. 0 None

Table 8-43 SQLSTATE class 01

SQLSTATE Explanation SQLCODE SQLWARN
01000 Terminated normally with a warning. 0 SQLWARN0='W'
0100C A dynamic result set was returned. 120 SQLWARN0='W'
0100D Another result set wass returned. 121 SQLWARN0='W'
0100E An attempt was made to return too many result sets. 120 SQLWARN0='W'
01R00 Terminated normally with a warning. Positive number other than 100 or 110 SQLWARN0=space-character or 'W'

Table 8-44 SQLSTATE class 02

SQLSTATE Explanation SQLCODE SQLWARN
02000 There is no data. 100 None
02001 There is no other result set to be returned. 100 None

Table 8-45 SQLSTATE class 40

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

Table 8-46 SQLSTATE class R0

SQLSTATE Explanation SQLCODE SQLWARN
R0000 Terminated abnormally. SQLCODE<0 SQLWARN6=' '

Table 8-47 SQLSTATE class R2

SQLSTATE Explanation SQLCODE SQLWARN
R2000 During a list search, a row that existed at the time of list creation was not returned. 110 None

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2011, 2014, Hitachi, Ltd.