exception handling in db2

[mailar]

Hi,
Can someone tell me how to perform exception handling in db2 UDFs
(not procedures) I am using db2 version 8.2 on windows xp platform.
Also , can I use SIGNAL statement in UDFs?.
I tried to use a exit handler code in my UDF as below

DECLARE EXIT HANDLER FOR SQLSTATE VALUE '23503'
SIGNAL SQLSTATE '75002'
SET MESSAGE_TEXT = 'Customer number is not known';
but it gave me an error saying

DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0104N An unexpected token "HANDLER" was found following "E INT;
DECLARE
EXIT". Expected tokens may include: "CONDITION". LINE NUMBER=12.
SQLSTATE=42601

[Serge Rielau]

SQL UDF do not support handlers:

dynamic-compound-statement

-+-------------+--BEGIN ATOMIC-------------------------------->

| (1) |
'-label:------'
--+-----------------------------------------+------------------> | .-------------------------------------. |
| V | |
'---+-| SQL-variable-declaration |-+--;-+-'
'-| condition-declaration |----'

.-,----------------------------.
V |----| SQL-routine-statement |--;-+--END--+-------+------------>< '-label-'

SQL-variable-declaration:

.-,-----------------.
V |
|--DECLARE----SQL-variable-name-+--data-type-------------------->

.-DEFAULT NULL------------.--+-------------------------+----------------------------------| '-DEFAULT--default-values-'

condition-declaration:

|--DECLARE--condition-name--CONDITION--FOR---------------------->

.-VALUE-.
.-SQLSTATE--+-------+-.--+---------------------+--string-constant---------------------|

SQL-routine-statement:

|--+-CALL----------------------------------------------+--------|
+-FOR-----------------------------------------------+
+-+-----------------------------------+--fullselect-+
| | .-,-----------------------. | |
| | V | | |
| '-WITH----common-table-expression-+-' |
+-GET DIAGNOSTICS-----------------------------------+
+-IF------------------------------------------------+
+-INSERT--------------------------------------------+
+-ITERATE-------------------------------------------+
+-LEAVE---------------------------------------------+
+-MERGE---------------------------------------------+
+-searched-delete-----------------------------------+
+-searched-update-----------------------------------+
+-SET Variable--------------------------------------+
+-SIGNAL--------------------------------------------+
'-WHILE---------------------------------------------'

In DB2 V8.2, if you are having complex logic I recommend using the CALL
statement to encapsulate the logic in a stored procedure.

Cheers
Serge