This shows you the differences between two versions of the page.
sqlstate [2015/09/23 20:27] 127.0.0.1 external edit |
sqlstate [2016/04/20 07:49] (current) dmtolpeko |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== SQLSTATE - PL/HQL Reference ====== | + | ====== SQLSTATE ====== |
SQLSTATE built-in variable contains a 5-character return status of the last SQL statement. | SQLSTATE built-in variable contains a 5-character return status of the last SQL statement. | ||
Line 8: | Line 8: | ||
<code language=sql> | <code language=sql> | ||
- | SET plhql.onerror = seterror; -- Prevent raising an exception | + | SET hplsql.onerror = seterror; -- Prevent raising an exception |
SELECT 1 FROM abc.abc; | SELECT 1 FROM abc.abc; | ||
Line 16: | Line 16: | ||
**Compatibility:** IBM DB2. | **Compatibility:** IBM DB2. | ||
- | **Version:** PL/HQL 0.03 | + | **Version:** HPL/SQL 0.3 |
**See also:** | **See also:** |