Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009

    Question Unanswered: Error handling for UDF creation

    Hi All,

    I have the script with following structure:

    create function My_Temporary_Function()
    language sql 
    begin atomic
    -- 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:
    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?


  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts