 |
 |
Archives of the TeradataForum
Message Posted: Thu, 12 Sep 2002 @ 19:35:45 GMT
| Subj: | | Re: SQLSTATE in stored procedures |
| |
| From: | | Dieter N�th |
David Wellman wrote:
| | I'm investigating the use of stored procedures and can't find the values for SQLSTATE documented anywhere. I know for that most of
the time I can always record the SQLCODE value which is the Teradata RDBMS error but there are probably situations where that may not be
available -- for instance a divide by zero error in SPL code? | |
| | Has anyone found this info? Also, is there a documented translation between SQLSTATE and SQLCODE anywhere? | |
V2R4.1:
SQL Ref. Vol. 1 - Chapter 1
SQL Ref. Vol. 6 -Appendix D
Messages Ref. - Chapter 19
btw, there's a Edit - Search in Acrobat Reader ;-)
Dieter
| |
