Benefits of Condition Handling - Advanced SQL Engine - Teradata Database
SQL Stored Procedures and Embedded SQL
- Product
- Advanced SQL Engine
- Teradata Database
- Release Number
- 17.05
- 17.00
- Published
- June 2020
- Language
- English (United States)
- Last Update
- 2021-01-23
- dita:mapPath
- xqq1557098602407.ditamap
- dita:ditavalPath
- lze1555437562152.ditaval
- dita:id
- B035-1148
- lifecycle
- previous
- Product Category
- Teradata Vantage™
- Reducing error-handling code in the applications by using CALL (to invoke a debugging stored procedure) and by modularizing the error code.
- Trapping exceptions in an application and resolving them in the same execution, without affecting the application.
- Handling most exceptions (which would otherwise cause the stored procedure to terminate), thereby allowing the stored procedure to continue with its execution.
- Providing a different handling mechanism for different conditions.