Benefits of Condition Handling - Advanced SQL Engine - Teradata Database
SQL Stored Procedures and Embedded SQL
- Product
- Advanced SQL Engine
- Teradata Database
- Release Number
- 17.10
- Published
- July 2021
- Language
- English (United States)
- Last Update
- 2021-07-28
- dita:mapPath
- vqj1592443206677.ditamap
- dita:ditavalPath
- vqj1592443206677.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.