====== ERRORCODE ======

ERRORCODE built-in variable contains the return code of the last SQL statement. The code can be zero (0), negative or positive:

| **ERRORCODE** | **Result** |
| 0 | Successful execution |
| Positive values | Warning  |
| Negative values | Error |


<code language=sql>
.if errorcode <> 0 then .quit 1
</code>

**Compatibility:** Teradata BTEQ.

**Version:** HPL/SQL 0.3.31

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