Tags for exception handling
handling of error “5878 – No error text is available”
Hi,   for TD error “5878 – No error text is available” standard exception handling with EXIT HANDLER FOR SQLEXCEPTION and EXIT HANDLER FOR SQLWARNING does not work. (TD 13.10)   Any suggestions how to handle this in stored procedure? It is not SQL error, we spotted it during the crash of application.  
5878 exception handling
User defined exception
Hi All, Can anyone explain how to handle user defined exception in Teradata with an example? Like if output from a select statement equal to a predefined value (1 or 10) it will throw an error?
exception handling
CAPTURING ERRORS IN STORED PROCEDURE
Format:HTML Format Version:1.0 StartHTML: 165 EndHTML: 13031 StartFragment: 314 EndFragment: 12999 StartSelection: 314 EndSelection: 314 REPLACE PROCEDURE DBNAME.PROC( IN PROD_NAME VARCHAR(50) ) BEGIN DECLARE SState INTEGER; DECLARE CONTINUE HANDLER FOR SQLSTATE '42000'
stored procedure exception handling
How do you stop demoted queries from hogging CPU?
We have implemented a 'Penalty Box' workload within TASM for queries that are demoted after reaching specific exception criteria with the idea that they go into a workload which has a low CPU allocation. We have seen a high % of CPU be taken into the Penalty box and remain with the query for a significant period.
tasm workload exception handling flow control
Handling Special Characters
Hi, I have a table which has a column where I can find special characters like &Altide; &Abc; etc. The total list of special characters is 110, I identified them using the logic anything between "&" and ";" is a special character and finally cross checked manually. Now I need to find and replace them in my table with space(" ").
special characters tuning teradata @Altide & exception handling varbyte unicode