====== SQLSTATE ======

SQLSTATE built-in variable contains a 5-character return status of the last SQL statement. 

SQLSTATE status code consists of a 2-character class code followed by a 3-character subclass code. Class code 00 (SQLSTATE '00000' i.e.) means the successful completion.

**Example:**

<code language=sql>
SET hplsql.onerror = seterror; -- Prevent raising an exception

SELECT 1 FROM abc.abc;
PRINT SQLSTATE;
</code>

**Compatibility:** IBM DB2.

**Version:** HPL/SQL 0.3

**See also:**
  * [[error-handling|Error Handling]]
  * [[sqlcode|SQLCODE]]
  * [[get-diagnostics|GET DIAGNOSTICS]]
  * [[resignal|RESIGNAL]]