How to define my own exception in db2 stored procedure

[amitabh.mehra]

the requirement that i have to meet is:
(pseudocode):

for each table in table_list
loop:
enable constraints on table to filter out all bad data that
violates db constraints;
take the count of the errors in temp_error_count;
total_error_count = total_error + temp_error_count;
if (total_error_count MAX_THRESHOLD)
then
RAISE MY_EXCEPTION
end if;
end loop;

How can i declare exception MY_EXCEPTION in db2?

[Lennart]

am***********@gmail.com wrote:

the requirement that i have to meet is:
(pseudocode):

for each table in table_list
loop:
enable constraints on table to filter out all bad data that
violates db constraints;
take the count of the errors in temp_error_count;
total_error_count = total_error + temp_error_count;
if (total_error_count MAX_THRESHOLD)
then
RAISE MY_EXCEPTION
end if;
end loop;

How can i declare exception MY_EXCEPTION in db2?

I dont think you need to declare it. Try:

RAISE_ERROR ('77000', 'TOTAL_ERROR_CNT MAX_THRESHOLD')

[Serge Rielau]

Lennart wrote:

RAISE_ERROR ('77000', 'TOTAL_ERROR_CNT MAX_THRESHOLD')

RAISE_ERROR() is the choice to raise an exception _within_ an SQL statement.
Commonly it's used as part of COALESCE or CASE-expression.
Within SQL PL the SIGNAL statement performs the same function.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab