Error handling for UDF creation

sineus · #1 (**permalink**) 02-11-09, 03:15

Hi All,

I have the script with following structure:

Code:

create function My_Temporary_Function()
language sql 
begin atomic
...
end/

-- sql that uses My_Temporary_Fuction

drop function My_Temporary_Function()/

The problem is that if My_Temporary_Function is already created in DB I get the following error after create statement:

Code:

DB2 SQL error: SQLCODE: -454, SQLSTATE: 42723, SQLERRMC: My_Temporary_Function
 Message: The signature provided in the definition for routine "My_Temporary_Function" matches the signature of some other routine that already exists in the schema or for the type.

Is there some way to check UDF existence in DB before creation or some way to handle error mentioned before?

Thanks,
Ilya

stolze · #2 (**permalink**) 02-11-09, 09:22

If you want to do this is a SQL script run through the DB2 CLP, the answer is "no". There, the typical approach is to just ignore such errors. For other situations, you can implement respective error checking in your application.

Internet Services

Web Development

Digital Marketing

Consumer Tech