0 - 5 of 5 tags for exception handling

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.

 

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?

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'

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.

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(" ").